InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 16:55:15 GMT20http://www.sqlservercentral.com/Forums/Topic885667-526-1.aspxWe 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.188 AUDIT_SCHEMA_OBJECT_ACCESS_EVENT 2010-03-17 12:42:36.673 userid01 CHQDRCLC6CWDK1 Server Database acct04\jschnur 6 Acct_Cal 8277 Microsoft SQL Server Management Studio - Query 5016 userid01 dbo 143 userid01 0 UPDATE table01 set [Acct_Period_No] = @1 WHERE [Acct_Period_No]=@2 187 AUDIT_SCHEMA_OBJECT_ACCESS_EVENT 2010-03-17 12:42:36.670 userid01 CHQDRCLC6CWDK1 Server Database acct04\jschnur 6 Acct_Cal 8277 Microsoft SQL Server Management Studio - Query 5016 userid01 dbo 143 userid01 0 UPDATE table01 set [Acct_Period_No] = @1 WHERE [Acct_Period_No]=@2 Thu, 18 Mar 2010 09:52:01 GMTjim.schnur