sysadmin 계정 조회

select spr.name, spr.default_database_name, spr.create_date, spr.modify_date, suser_name(srm.role_principal_id) as server_role_name from sys.server_principals as spr with (nolock) inner join sys.server_permissions as spm (nolock) on spm.grantee_principal_id = spr.principal_id left join sys.server_role_members as srm with (nolocK) on spr.name = suser_name(srm.member_principal_id) where 1=1--spr.name not in () and spr.name not like '##%' and spr.name not like 'NT %' and suser_name(srm.role_principal_id) = 'sysadmin' and spr.is_disabled = 0 order by spr.type,spr.name