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?