使用触发器时碰到 OLE DB provider "SQLNCLI" 错误
本地数据库创建了如下的触发器
CREATE TRIGGER tr_in_t on [Northwind].[dbo].[t]
FOR INSERT
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @id INT, @name VARCHAR(20);
SELECT @id=id, @name=name FROM inserted;
INSERT INTO TestLocal.pubs.dbo.test(id,name) VALUES(@id,@name);
END
// 在本地数据库测试插入一条信息时,会不会同步插入到远程数据库指定的表
INSERT INTO [Northwind].[dbo].[t]
([id]
,[name])
VALUES
(3,'sf')
触发器执行,没有报任何错误, 但是单独执行 insert 语句时,总是报错。
link server 是测试过的,没有问题。
报错信息:
OLE DB provider "SQLNCLI" for linked server "TestLocal" returned message
"The partner transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Procedure tr_in_t, Line 9
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "TestLocal" was unable to begin a distributed transaction.