View/check linked server logins?

• daft

  SSC Eights!

  Points: 806

  More actions

  June 12, 2009 at 5:04 am

  #134992

  hi guys,

  Easy one i think - how can i view or check my linked server logins?

  I know to use sp_addlinkedsrvlogin to add logins, and I know to use sp_linkedservers to view my linked servers, but can't see any easy way of checking which logins have been added to those (or any) linked servers

  TIA

• UNCRushFan

  SSC Veteran

  Points: 281

  More actions

  June 12, 2009 at 2:40 pm

  #1008901

  Try:

  select * from sys.linked_logins

  That will hopefully get you started....

  Membrane.Inside("Insane");

• daft

  SSC Eights!

  Points: 806

  More actions

  June 17, 2009 at 8:35 am

  #1010985

  thanks, that's pretty useful, even though we still need to do a bit of legwork to associate the logins with the linked servers

  a "sp_linkedserverlogins" would be nice, just because i'm ultra-lazy

  thanks again

• SQLArnold

  SSCommitted

  Points: 1847

  More actions

  March 12, 2015 at 6:08 pm

  #1783752

  here you go, ask and you receive.

  sp_helplinkedsrvlogin

  The pain of Discipline is far better than the pain of Regret!

• Bharti.Vadgama

  SSC Rookie

  Points: 49

  More actions

  January 13, 2016 at 5:03 am

  #1851533

  Hi,

  Need to know what Local login I am using in my linked server 2008?

  Thanks in advance