如题
------解决方案--------------------
http://blog.csdn.net/fengfangfang/archive/2006/07/28/993882.aspx
------解决方案--------------------
类似这样:
USE master
GO
EXEC sp_addlinkedserver
'svr_lnk ',
'Oracle ',
'MSDAORA ',
'MyServer '
GO
EXEC sp_addlinkedsrvlogin 'LONDON Mktg ', 'false ', 'sa ', 'Admin ', NULL
GO
CREATE TRIGGER TR_1 ON TABLE1
AS
INSERT svr_lnk.dbname.dbo.table2 value(...)
------解决方案--------------------
类似这样:
USE master
GO
EXEC sp_addlinkedserver
'svr_lnk ',
'Oracle ',
'MSDAORA ',
'MyServer '
GO
EXEC sp_addlinkedsrvlogin 'svr_lnk ', 'false ', 'sa ', 'Admin ', NULL
GO
CREATE TRIGGER TR_1 ON TABLE1
AS
INSERT svr_lnk.dbname.dbo.table2 value(...)