I have three SQL Server 7.0. A, B and C. I have script from Server A to
query the linked server B.db.dbo.table and use
begin transaction aaa
then do some work and then
commit transaction aaa.
It is running OK to run against on server B.db.dbo.table, recordset
returned. But when running the same script from same server A to query
Server C.db.dbo.table, then returns message 'MSDTC on server 'C' is
I check three server's MSDTC service is running. I restarted it. And They
are all in same version and Service Pack.
Anyone know what's happen? Please help