Please help me on the below scenario.
* SQL Server 'A' has 1..n different linked servers pointing Server 'B' with different remote logins.
* Password got modified for one account i.e. 'login1' in Server 'B'
Can you please help how to fetch the linked servers using remotelogin as 'login1' . so that i can reset password for only those linked servers
Thanks in advance !