Simple script to get logins and default database names

Posted by Peter Larsson on SQL Team See other posts from SQL Team or by Peter Larsson
Published on Mon, 14 Jun 2010 11:27:34 GMT Indexed on 2010/06/14 11:54 UTC
Read the original article Hit count: 312

SELECT     u.name,

           l.dbname

FROM       sys.sysusers AS u

INNER JOIN sys.syslogins AS l ON l.sid = u.sid

© SQL Team or respective owner