22,210
社区成员
发帖
与我相关
我的任务
分享
createtrigger tr_test
on dbo.testtb
after insert
as
declare @sql nvarchar(max)
declare @dbname varchar(100)
declare @tblname varchar(100)
declare @type varchar(10)
declare @Tsql nvarchar(4000)
declare @PostTime varchar(20)
declare @LoginName varchar(20)
declare @hostname varchar(20)
begin
select @dbname=[dbname],@Tsql=[TSQLCommand],@PostTime=[PostTime],@LoginName=[LoginName],@hostname=[hostname] from inserted
insert into 服务器B.testdb.dbo.testdb([dbname],[TSQLCommand],[PostTime],[LoginName],[hostname])
values(@dbname,@Tsql,@PostTime,@LoginName,@hostname)
end
sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO