Add Linked Servers using query

• 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‘