• Halt audit trace if audit file doesn’t rollover

    I have a security requirement for SQL Server 2005 and 2008: "SQL Server shall be configured to halt if a failure in audit file rollover occurs". How do I accomplish this?

    VelameLaCosa110 pointsBadges:
  • Exclude Login from SQL Audit Trace

    I'm working on a stored procedure to capture SQL Server 2005 Audit events.  There is an Application login/user that generates a LOT of rows because it is constatntly hitting the database. I'm using something like: exec sp_trace_setevent @TraceID, 14, 11, @on How do I EXCLUDE a specific login...

    VelameLaCosa110 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.