Issues related to SQL Server Patches

1Distributed transactions

Http://community.csdn.net/Expert/topic/4874/4874208.xml? Temp =. 298443.

Execute the following statement:

Insert into AA select * From srva. DBA. DBO. ga-

Begin tran

Insert into B select * from AA

Commit tran

 

Error:

Server: Message 7391, level 16, status 1, process up_transproc, row 24

This operation cannot be performed because the ole db Provider 'sqlodb' cannot start distributed transactions.

[OLE/DB Provider returned message: a new transaction cannot be registered with a specified transaction processor.

 

A:

SQL Server 2005 and SQL Server 2000 SP3 and above do not have this problem ..