AUDIT_SCHEMA_OBJECT_ACCESS_EVENT Produces Failed and Successful Event

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Shas3 » AUDIT_SCHEMA_OBJECT_ACCESS_EVENT Produces...

AUDIT_SCHEMA_OBJECT_ACCESS_EVENT Produces Failed and Successful Event

Rate Topic

Display Mode

Topic Options

Author

Message

jim.schnur

Posted Thursday, March 18, 2010 9:52 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 23, 2010 10:32 AM
Points: 4, Visits: 35

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.

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

Post #885667

« Prev Topic | Next Topic »

Permissions