|
|
Posted by Erland Sommarskog on 09/11/06 07:22
(dotnetfellow@yahoo.com) writes:
> The system has worked for two years.
>
> SQL Server 2000 runs on Windows 2000 Server "A".
>
> Another instance of SQL Server 2000 was moved from Windows 2000 Server
> "B" old to Windows 2003 Server "B" new, by restoring a backed
> up copy from old to new.
>
> The system has cross server updates, where Server "A" is updating
> records in very large tables on Server "B".
>
> After the move from Server "B" old to Server "B" new, suddenly
> the cross server updates fail, but only when they are conducted within
> a Begin and Commit Transaction batch.
>
> The system works when I remove the Begin and Commit Transaction, and no
> longer have them run in a batch.
Any error message you could share with us?
Since it works without a transaction, it sounds as if DTC is not running
on the new server B.
> Also, I had a cross server update, having "A" update records in
> "B", from a delete trigger residing on "A" table. Deletes
> against the "A" table fail so long as the trigger remains. Once I
> remove the delete trigger from the "A" table, I can now delete
> records on the "A" table.
A trigger always operates in a transaction defined by the statement that
fired it, so this is consistent with the above.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|