Post reply

How To Get Login Existence in mutiple databases

  • April 27, 2014 at 11:00 pm

    #290592

    I have three databases in sql 2008 such as

    db1, db2, db3 and a login user "gaurav"

    this login have access only db1 and db2. not db3.

    so question is : can we get a list which show me login user "gaurav" exists in db1 and db2 only by a single query command

    or I have to select each db like

    Use db1

    go

    select * from sys.logings

    go

    thanks

  • April 27, 2014 at 11:37 pm

    #1709068

    try this...

    sp_helplogins gaurav

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

Viewing 2 posts - 1 through 1 (of 1 total)

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