- First, get all server name check if the server already linked or not
exec sp_linkedservers
- Link server who has windows authentication
exec sp_addlinkedserver @server=’SERVERNAME’
- Link server who has login credentials
exec sp_addlinkedsrvlogin ‘SERVERNAME’, ‘false’, null, ‘USERNAME’, ‘PASSWORD‘