AUDIT_SCHEMA_OBJECT_ACCESS_EVENT Produces Failed and Successful Event

  • 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

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply