Post reply

Trigger to detect new SYSADMIN

  • February 5, 2004 at 6:23 pm

    #83810

    I would like to create a trigger that will alert me if anyone is added to the sysadmin role.  And preferably who added them.

    Any suggestions on how to do this?

    Thanks,

    Glen Anderson

     

  • February 5, 2004 at 9:32 pm

    #492987

    Without modifying the system stored procedure sp_addsrvrolemember, there's no real way as triggers are not guaranteed to fire on system tables. You could audit the role periodically, but that doesn't tell you who. Probably the best way is to run traces and review them on a regular basis.

     

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply