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?
