Linked Server Creation

Question

I would like to add a linked server to a remote sql server.
The purpose would be to copy table from that server to my local sql server.

My remote server name: remoteserver
username: sa
password: sa

Can any body can share the sql for creating linked server?

Mike · Answer

Once you have created the linked server you could use sp_addlinkedsrvlogin @rmtsrvname = ' linkerservername '@locallogin = ''@rmtuser = 'sa'@rmtpassword = 'sa' or you can right click properties the new linked server and set the username properties there.

Jean Paul · Answer

Thank You very much Mike.

Jean Paul · Answer

Thank You. Where is the username and password I could mention?

Mike · Answer

Hi Try this : exec sp_addlinkedserver @server = ' servername ' @srvproduct = '' @provider = 'sqloledb' @datasrc = ' serverhostname ' @catalog = ' dbname ' Substituting the above for your names. Thanks