SQL uses a linked server to execute stored procedures on a remote database

Original: SQL uses a linked server to execute stored procedures on a remote database

-- create a linked server

exec sp_addlinkedserver' server_tmp ',','SQLOLEDB ', ' remote server name orIPAddress'

exec sp_addlinkedsrvlogin' server_tmp ',' false ', NULL,' User name','Password'

exec sp_serveroption' Server_lnk ',' rpc out ',' true ' -- This allows a call to a stored procedure on a linked server

Go

-- Call:

exec server_tmp. Database name.dbo.Procedure Name'Parameters'

-- To remove a connection server EXEC sp_dropserver '  server_tmp','droplogins' 

SQL uses a linked server to execute stored procedures on a remote database