InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 19:34:48 GMT20http://www.sqlservercentral.com/Forums/Topic851896-146-1.aspxCan anyone help on my second query please....Mon, 25 Jan 2010 05:08:41 GMThaichellshttp://www.sqlservercentral.com/Forums/Topic851896-146-1.aspxThanks a lot ! One more query. I used this login/pwd to create Distributor db and so all my replications are runing on this. Can you please help me with the command to reset the password for the Distribution DB.Thanks again !Fri, 22 Jan 2010 06:21:14 GMThaichellshttp://www.sqlservercentral.com/Forums/Topic851896-146-1.aspxtry this...[code]select srv.name,lgn.Remote_namefrom sys.servers srv, sys.linked_logins lgnwhere srv.server_id=lgn.server_id and lgn.remote_name='login1'[/code]also refer to the BOL link[url]ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/06d53a67-7804-4f1f-8201-3e42dc48ba79.htm[/url]Fri, 22 Jan 2010 05:16:57 GMTSqlfrenzyhttp://www.sqlservercentral.com/Forums/Topic851896-146-1.aspxHi All,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 serversThanks in advance !Fri, 22 Jan 2010 04:17:34 GMThaichells