How can you determine through T-SQL which logins have sysadmin?
Thanking you
1 Answer
-- 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
-
1
sysloginsis now deprecated. avoid using it.– user37701Commented Jan 8, 2018 at 3:46 -
-
All the
dbo.sys*views are deprecated since version 2005, if memory serves. There are typically similarly named views in thesysschema nowadays. Commented Jan 8, 2018 at 7:57