1:服务器操作EXEC sp_addlinkedserver
'Test', --名称
'',
'MSDASQL',
NULL,
NULL,
'DRIVER={SQL Server};SERVER=服务器名;UID=sa;PWD=密码;'
GO
-------以上为添加连接服务器exec sp_addlinkedsrvlogin 'test','false','sa','sa',''2:CREATE TRIGGER Ta ON dbo.T
FOR DELETE
AS
begin
insert into anotherserver.db.dbo.T select * from deleted
end
'Test', --名称
'',
'MSDASQL',
NULL,
NULL,
'DRIVER={SQL Server};SERVER=服务器名;UID=sa;PWD=密码;'
GO
-------以上为添加连接服务器exec sp_addlinkedsrvlogin 'test','false','sa','sa',''2:CREATE TRIGGER Ta ON dbo.T
FOR DELETE
AS
begin
insert into anotherserver.db.dbo.T select * from deleted
end
可以说说为什么么?