Create a linked server. Linked servers allow users to distribute heterogeneous queries to OLE DB data sources. Create a link using sp_addlinkedserver
Server, you can run distributed queries against the server. If the linked server is defined as an instance of SQL Server, the remote stored procedure can be executed.
http://msdn.microsoft.com/zh-cn/library/ms190479 (sql.90). aspx
EXECUTE sp_addlinkedserver @server = ' DB1 ', @srvproduct = ', @provider = ' sqloledb ', @datasrc = ' xxx.xxx.xxx.xxx ' Go
Set server options for remote and linked servers.
Http://msdn.microsoft.com/zh-cn/library/ms178532.aspx
Execute sp_serveroption n ' DB1 ', n ' rpc out ', n ' true '
go
EXECUTE sp_serveroption n ' DB1 ', n ' rpc ', n ' true '
go
Create or update mappings between logins on the local instance of SQL Server and security accounts on the remote server.
http://msdn.microsoft.com/zh-cn/library/ms189811 (sql.90). aspx
EXECUTE sp_addlinkedsrvlogin ' DB1 ', ' false ', NULL, ' sa ', ' Password ' go