Post reply

query to list linked server user

  • January 28, 2013 at 2:51 am

    #288067

    Hi

    How do i query the SQL server to list the "remote login" of a linked server?

    it sounds so simple but i cannot find the information anywhere!

    sorry if this has been asked before, i tried searing but found nothing of use

    /J

  • January 28, 2013 at 3:48 am

    #1581513

    Try the sys.linked_logins & sys.remote_logins catalog views - should contain the information you're after.

  • January 28, 2013 at 4:52 am

    #1581547

    thanks!

  • January 28, 2013 at 5:18 am

    #1581558

    No problem!

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

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