Hi, sntiwary !

Thanks for a suggestion but it doesn't solve the issue because in this case there is no point in transactions. I want to put inside transaction creation of...

Sntiwary, I haven't found any solution yet.

As an alternative in my case I can pull data to the temp table on the linked server instead pushing it to the linked...

I have the same error, below is a small sample to reproduce it (both servers are MS SQL 2005 SP2).

It looks like 'insert' and 'drop' operations joint together and I...