Post reply

View/check linked server logins?

  • 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 🙂

  • June 12, 2009 at 2:40 pm

    #1008901

    Try:

    select * from sys.linked_logins

    That will hopefully get you started....

    Membrane.Inside("Insane");

  • 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

  • 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!

  • 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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply