Home Forums SQL Server 2008 SQL Server Newbies How to create a policy that will periodically check the membership of sysadmin? RE: How to create a policy that will periodically check the membership of sysadmin?

  • It's a SQL statement in the field textbox, Google ExecuteSQL. The select statement is:

    SELECT serverroles.name

    FROM sys.server_principals AS serverroles

    JOIN sys.server_role_members serverrolemembers

    ON serverrolemembers.role_principal_id = serverroles.principal_id

    JOIN sys.server_principals serverrolemember

    ON serverrolemembers.member_principal_id =

    serverrolemember.principal_id

    WHERE serverrolemember.name = 'BUILTIN\Administrators'

    You can change the where clause if your interested in more than just the 'BUILTIN\Administrators' group.