Post reply

Event ID for drop db user event

  • January 6, 2013 at 6:20 am

    #272438

    Hi all,

    is there an Event ID that gets written into Windows log when the db user is deleted? The only thing I find is sp_trace_setevent for the default trace, such as below.

    130

    Audit Database Principal Management Event

    Occurs when principals, such as users, are created, altered, or dropped from a database.

    Also, I found Server Audit setting, but nothing like a general event ID in the App log that I can use for monitoring. Is that accurate?

  • January 7, 2013 at 3:17 am

    #1574228

    No, none of this information is written into the event log. If you want to track user deletions you'll need to use the default trace, as you've found.

  • January 7, 2013 at 3:46 am

    #1574241

    There will no windows log,

    Sql manages internally and u can access it through sql only.

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

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