SQL Server creates a stored procedure example for the linked Server, and SQL stored procedure

SQL Server creates a stored procedure example for the linked Server, and SQL stored procedure

Create a linked server. The linked server allows you to perform distributed heterogeneous queries on the ole db data source. Create a link using sp_addmediaserver
You can run distributed queries on the server. If the linked Server is defined as an SQL Server instance, a remote stored procedure can be executed.
Http://msdn.microsoft.com/zh-cn/library/ms190479 (SQL .90). aspx

EXECUTE sp_addmediaserver @ server = 'db1', @ srvproduct = '', @ provider = 'sqloledb', @ datasrc = 'xxx. xxx. xxx. XXX' GO

Set server options for remote servers and linked servers.
Http://msdn.microsoft.com/zh-cn/library/ms178532.aspx

EXECUTE sp_serveroption N 'db1', N 'rpc out', N 'true' GOEXECUTE sp_serveroption N 'db1', N 'rpc ', N 'true' GO

Create or update the ing between the login name on the local SQL Server instance and the security account on the remote Server.
Http://msdn.microsoft.com/zh-cn/library/ms189811 (SQL .90). aspx

EXECUTE sp_add1_srvlogin 'db1', 'false', NULL, 'sa ', 'Password' GO