Posted by Altemir on 03/20/06 18:10

Yes that was the problem: My select statement was querying Database A,
which involved a linked table to Database B. Although, technically, it
was not a "Linked Server" link -- it was a "Transact SQL" link -- but
the outcome appears to be the same.

I was able to re-write the UPDATE statement so that no linked tables
were involved. This actually resulted in a better design.

Thank you very much for your help, Doug, Erland, and Mark!!!!!!!

[Back to original message]