CREATE TRIGGER [tr_Test] ON dbo.test FOR INSERT AS SET IMPLICIT_TRANSACTIONS OFF begin tran insert Test.newtest.dbo.w_test(hxString,Ynn) values('xingxing','0') commit tran--执行插入过程的时候还是出原来的错.
Could not start a transaction for OLE DB provider 'MSDASQL'. [OLE/DB provider returned message: ODBC 驱动程序无法启动新事务。] [OLE/DB provider returned message: [Microsoft][ODBC 驱动程序管理器] 在事务服务器组件事务中发生非法操作]
SET IMPLICIT_TRANSACTIONS OFF2、
本地和远程都需要启动
DISTRIBUTED TRANSACTION COORDINATOR服务。
insert xx.xx.dbo.xx ......
commit tran也不行
FOR INSERT
AS
SET IMPLICIT_TRANSACTIONS OFF
begin tran
insert Test.newtest.dbo.w_test(hxString,Ynn) values('xingxing','0')
commit tran--执行插入过程的时候还是出原来的错.
[OLE/DB provider returned message: ODBC 驱动程序无法启动新事务。]
[OLE/DB provider returned message: [Microsoft][ODBC 驱动程序管理器] 在事务服务器组件事务中发生非法操作]
如果在查询器里只写insert Test.newtest.dbo.w_test(hxString,Ynn) values('xingxing','0') 就可以执行!
insert xx.xx.dbo.xx ......
commit tran在触发器里和这个一样都不能启动分布事务
FOR INSERT
AS
insert Test.newtest.dbo.w_test(hxString,Ynn) values('xingxing','0')
这样也还是出错阿.