Article ID: 2678370
Consider the following scenario:
spid ## Using 'dbghelp.dll' version '4.0.5'
SELECT NAME AS AUDITNAME FROM SYS.SERVER_AUDITS WHERE ON_FAILURE = 2 AND PREDICATE IS NOT NULL
If the error messages are logged in the SQL Server error log, the issue occurred.
Cumulative update information
SQL Server 2012The fix for this issue was first released in Cumulative Update 1. For more information about how to obtain this cumulative update package for SQL Server 2012, click the following article number to view the article in the Microsoft Knowledge Base:
2679368Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2012 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/2679368/ )Cumulative Update package 1 for SQL Server 2012
(http://support.microsoft.com/kb/2692828/ )The SQL Server 2012 builds that were released after SQL Server 2012 was released
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
To work around this issue, take one of the following actions:
For more information about SQL Server audit, visit the following Microsoft Developer Network (MSDN) website:
General information about SQL Server audit
If you try to disable the audit, the disable operation may fail. This behavior may occur because the audit depends on the Audit Action groups that are specified in the server audit specification, such as SUCCESSFUL_LOGIN_GROUP, AUDIT _CHANGE_GROUP. These audits can be disabled or removed only when SQL Server is started under minimal configuration (that is, with the -f startup parameter). You can use the following query to identify the audits that can cause the problem that is described in the "Symptoms" section:
SELECT name as AuditName FROM sys.server_auditsWHERE on_failure = 2 AND predicate IS NOT NULL
Contact us for more help
Connect with Answer Desk for expert help.