Thinking outside the box

Patron Saint of Lost Yaks
posts - 202, comments - 734, trackbacks - 4

My Links

Advertisement

News

Archives

Post Categories
<< Simple script to get referenced table and their column names | Home | SQL Server 2008 Compression >>

Simple script to get logins and default database names

SELECT     u.name,
           l.dbname
FROM       sys.sysusers AS u
INNER JOIN sys.syslogins AS l ON l.sid = u.sid

Print | posted on Monday, June 14, 2010 1:27 PM | Filed Under [ SQL Server 2008 Administration SQL Server 2005 ]

Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET

Copyright © Peter Larsson