Tuesday, July 3, 2012

Script to identify users having sysadmin role

SELECT sp.name, sp.type_desc, sp.create_date FROM sys.server_principals sp, sys.server_role_members srm
WHERE sp.principal_id = srm.member_principal_id AND SRM.role_principal_id = 3

No comments: