Query/consulta para obtener los usuario con rol sysadmin en un motor de Base de Datos SQL Server.
SELECT ‘Name’ = sp.NAME
,sp.is_disabled AS [Is_disabled]
FROM sys.server_role_members rm
,sys.server_principals sp
WHERE rm.role_principal_id = SUSER_ID(‘Sysadmin’)
AND rm.member_principal_id = sp.principal_id