日期:2014-05-17 浏览次数:20733 次
begin transaction
set nocount on
insert T1 aa values (1)
update Pc.Db1.dbo.T2 set b=2 where cc=1
if(@ExecFlag<>1)
begin
rollback transaction
end
else
begin
commit transaction
end
http://blogs.msdn.com/b/distributedservices/archive/2010/03/25/import-of-microsoft-distributed-transaction-coordinator-ms-dtc-transaction-failed-0x8004d00e-xact-e-notransaction.aspx