我有一个SQL Server 2008 RDS实例,我在本地计算机SQL server 2014上创建了一个链接服务器(AWSMSSQL)。
现在,我从本地计算机数据库表中创建了insert、update和delete触发器
USE [test]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[ms_test] ON [dbo].[localservertable]
FOR INSERT, UPDATE, DELETE
AS
BEGIN
declare @iddata int;
declare @option int;
select @iddata=i.[id] from inserted i;
select @option=i.[option] from inserted i;
IF NOT EXISTS(SELECT * FROM inserted)
BEGIN
select @option=d.[option] from deleted d;
DELETE FROM [AWSMSSQL].[test].[dbo].[localservertable] WHERE [option]=@option;
END
ELSE
BEGIN
IF NOT EXISTS(SELECT * FROM deleted)
BEGIN
INSERT INTO [AWSMSSQL].[test].[dbo].[localservertable] VALUES (@iddata,@option);
END
ELSE
BEGIN
UPDATE [AWSMSSQL].[test].[dbo].[localservertable] SET [option]=9 WHERE id=1;
END
END
END;当我更新本地数据库表时,使用代码
UPDATE [dbo].[localservertable]
SET [option] = 5
WHERE [iddata]=1它显示了一个错误
OLE DB provider "SQLNCLI11" for linked server "AWSMSSQL" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Procedure ms_item, Line 29
The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "AWSMSSQL" was unable to begin a distributed transaction.我找到了这个link,它告诉我如何修改MSDTC的设置。但在进行更改后,我重新启动了AWS RDS服务器和本地计算机。但同样的错误也会存在。帮我走出这个错误


谢谢你!!
发布于 2018-04-24 20:38:25
触发器隐式启用XACT_ABORT。启用此设置的错误将自动导致事务回滚(使用RAISERROR语句在代码中引发的错误除外)。
发布于 2018-04-24 14:30:21
目前RDS似乎不支持分布式事务。
发布于 2020-05-07 00:18:29
RDS for SQL Server现在支持分布式事务- https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-rds-for-sql-server-now-supports-distributed-transactions/
https://stackoverflow.com/questions/49994712
复制相似问题