How to determine which logins have sysadmin?

Question

How can you determine through T-SQL which logins have sysadmin?

Thanking you

score 0 · Answer 1 · answered Jan 08 '18 at 03:37

0

-- sysadmin = 1 indicates that the login has sysadmin

SELECT name, dbname DBNAME,sysadmin SYSADMIN, denylogin, isntname, isntgroup, isntuser

FROM master.dbo.syslogins

WHERE sysadmin = 1

answered Jan 08 '18 at 03:37

A.Chetcuti

1

syslogins is now deprecated. avoid using it. – Jan 08 '18 at 03:46
Which version is it deprecated? I am using 2008 - 2017 – A.Chetcuti Jan 08 '18 at 03:59
All the dbo.sys* views are deprecated since version 2005, if memory serves. There are typically similarly named views in the sys schema nowadays. – Daniel Hutmacher Jan 08 '18 at 07:57

1 Answers1