Its a wonder I ever figure anything out in SQL. <BR><BR>Here is my current problem.<BR><BR>I&#039;m trying to run an update on a local DB which needs information from a linked database so the query is like<BR><BR>UPDATE products SET cost = live.cost FROM products LEFT OUTER JOIN live ON group.group_id = products.group_id<BR><BR>But I&#039;m getting this error message<BR><BR>Server: Msg 7391, Level 16, State 1, Line 1<BR>The operation could not be performed because the OLE DB provider &#039;SQLOLEDB&#039; was unable to begin a distributed transaction.<BR>[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]<BR><BR>Thanks again for any help!<BR><BR><BR><BR>