Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

AUDIT_SCHEMA_OBJECT_ACCESS_EVENT Produces Failed and Successful Event Expand / Collapse
Author
Message
Posted Thursday, March 18, 2010 9:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse