QQ3TD48K

1OLE DB provider "SQLNCLI11" for linked server "TMP-DBA-DB" returned message "The transaction manager has disabled its support for remote/network transactions.".
2Msg 7391, Level 16, State 2, Procedure AuditlDealerDebitAuditTrailTEST, Line 22
3The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "TMP-DBA-DB" was unable to begin a distributed transaction.
4	
5create trigger dbo.AuditlDealerDebitAuditTrailTEST
6on [dbo].[lDealerDebitAuditTrailTEST] 
7
8after UPDATE, INSERT, DELETE
9as 
10
11declare @TableName varchar(20), @User varchar(20), @PCNo varchar(20), @server nvarchar(30), @Database varchar(30), 
12        @table varchar(30),@activity varchar(20), @date datetime;
13
14begin
15         set  @TableName = 'lDealerDebitAuditTrailTEST' 
16
17if exists(SELECT * from inserted) and exists (SELECT * from deleted)
18begin
19    SET @User = SYSTEM_USER;
20    set @PCNo = HOST_NAME();
21    set @server = @@SERVERNAME;
22    set @Database = DB_NAME();
23    Set @table = @TableName;
24    SET @activity = 'UPDATE';
25    set @date = GETDATE();
26      INSERT into [TMP-DBA-DB].[Josel_TestDB].[dbo].[audit](ExecutedBy,  PCNo, "Server", "Database", "Table", Activity, ExecutedOn)
27         values (@User, @PCNo,  @server, @Database,  @table, @Activity, @date);
28end
29
30If exists (Select * from inserted) and not exists(Select * from deleted)
31begin
32    SET @Activity = 'INSERT';
33    SET @User = SYSTEM_USER;
34    set @PCNo = HOST_NAME();
35    set @server = @@SERVERNAME;
36    set @Database = DB_NAME();
37    Set @table = @TableName;
38    set @date = GETDATE();
39     INSERT into [TMP-DBA-DB].[Josel_TestDB].dbo.audit(ExecutedBy,  PCNo, "Server", "Database", "Table", Activity, ExecutedOn)
40         values (@User, @PCNo,  @server, @Database,  @table, @Activity, @date);
41    end
42If exists(select * from deleted) and not exists(Select * from inserted)
43begin 
44    SET @activity = 'DELETE';
45    SET @User = SYSTEM_USER;
46    set @PCNo = HOST_NAME();
47    set @server = @@SERVERNAME;
48    set @Database = DB_NAME();
49    Set @table = @TableName;
50    set @date = GETDATE();
51     INSERT into [TMP-DBA-DB].[Josel_TestDB].dbo.audit(ExecutedBy,  PCNo, "Server", "Database", "Table", Activity, ExecutedOn)
52         values (@User, @PCNo,  @server, @Database,  @table, @Activity, @date);
53    end
54
55    end
56GO