SQLServer Auditing and Alerts

Copper Contributor

We have enabled SQL Server Query auditing with 'On Audit Log Failure' set to Continue, so not to lock up the system.   I would like to setup a SQL Server Agent Alert that would fire when the Drive is full and it is not able to write the audit to the file.  


Any help?

1 Reply
And what is the problem doing so?