We have enabled via a service broker the AUDIT_SCHEMA_OBJECT_ACCESS_EVENTs. During testing we are finding a successful and failed event created for a failed transaction. We are using SQL Server 2005. Is there anyway to stop this, perhaps using FANIN? Any help will be greatly appreciated.
Example events below are for a single update statement. Identifying information removed.
188AUDIT_SCHEMA_OBJECT_ACCESS_EVENT2010-03-17 12:42:36.673userid01CHQDRCLC6CWDK1ServerDatabaseacct04\jschnur6Acct_Cal8277Microsoft SQL Server Management Studio - Query5016userid01dbo143userid010UPDATE table01 set [Acct_Period_No] = @1 WHERE [Acct_Period_No]=@2
187AUDIT_SCHEMA_OBJECT_ACCESS_EVENT2010-03-17 12:42:36.670userid01CHQDRCLC6CWDK1ServerDatabaseacct04\jschnur6Acct_Cal8277Microsoft SQL Server Management Studio - Query5016userid01dbo143userid010UPDATE table01 set [Acct_Period_No] = @1 WHERE [Acct_Period_No]=@2