How to view MSSQL 2005 logins:The insights of an SQL geek


The insights of an SQL geek: How to view MSSQL 2005 logins

Wednesday, January 21, 2009

How to view MSSQL 2005 logins

hello all,
use this to view your 2005 server logins


SELECT p.sid, p.name, p.type, p.is_disabled, p.default_database_name, l.hasaccess, l.denylogin FROM
sys.server_principals p LEFT JOIN sys.syslogins l
ON ( l.name = p.name ) WHERE p.type IN ( 'S', 'G', 'U' ) AND p.name <> 'sa'


Enjoy

Itay

1 comment:

  1. oh God!
    thank you!
    I spend 2 hours looking for this by myself)))

    ReplyDelete