I found out it was the update trigger for the table that was causing the error. As soon as I delete the update trigger, it works. Thanks for...

It works with the inner join syntax as you suggested. However, I need a where clause to the update statement and it fails with the same error with the...

Thanks for all the feedbacks - great help! The detach/attach is to shrink the logs which sometimes have grown too big. I tried the force shrink log script....