syntax: EXEC sp_addlinkedsrvlogin ‘linked servername’, ‘false’, ‘local login’, ‘remote login name’, ‘remote login password’
EXEC sp_addlinkedsrvlogin ‘LNK_PROD’, ‘false’, ‘domain\abc’, ‘user1’, ‘Password!’
syntax: EXEC sp_addlinkedsrvlogin ‘linked servername’, ‘false’, ‘local login’, ‘remote login name’, ‘remote login password’
EXEC sp_addlinkedsrvlogin ‘LNK_PROD’, ‘false’, ‘domain\abc’, ‘user1’, ‘Password!’