I needed a way to check for the sysadmin role on an instance. I came up with this small query that does that:
1 2 3 |
SELECT Name,IS_SRVROLEMEMBER('sysadmin', name) AS SYSADMIN FROM sys.server_principals WHERE (SELECT IS_SRVROLEMEMBER('sysadmin', name)) = 1 |