MSSQL see witch user that have SysAdmins access

WIth this command you can see witch user that have SysAdmins access.

SELECT   name,type_desc,is_disabled
FROM     master.sys.server_principals 
WHERE    IS_SRVROLEMEMBER ('sysadmin',name) = 1
ORDER BY name

 

Leave a Reply

Your email address will not be published. Required fields are marked *