Few notes

These are just few notes, hopefully I'll have a minute soon to explain why do I post it here. Problem 1: 2 linked servers with different logins causing following error: OLE DB provider "MSDASQL" for linked server returned message "[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user .... Solution:

EXEC sp_addlinkedsrvlogin 'server1', 'false', NULL, 'user', 'test'