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 · Accepted 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