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
select * from sys.logings