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

Filter audit in SQL 2012 Expand / Collapse
Author
Message
Posted Friday, April 11, 2014 5:20 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 3:42 PM
Points: 82, Visits: 660
Trying to create an audit that goes to the application log. With a certain criteria, select, update, delete etc.. where like 'example'-- some criteria

is there any reference out there that could give me some examples?


Thanks in advance
Post #1561152
Posted Saturday, April 12, 2014 6:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 13,872, Visits: 28,270
Your best bet for something like this would be to use Extended Events. You can capture execution of queries and it has very good filtering so you can just get the ones you want.

By the way, you're posting a SQL Server 2012 question in the SQL Server 2014 forums. In this case the answer is identical between the versions, but in other cases, it might not be. I'd suggest trying to keep your questions in the corresponding forums just so you get better, more useful, answers.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1561195
Posted Saturday, April 12, 2014 9:33 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 3:42 PM
Points: 82, Visits: 660
Thanks I didn't realize I posted in the wrong version. For the extended events we can't use because we have a 3rd party app that can only pull the information from the events.

Thanks again
Post #1561215
Posted Monday, April 14, 2014 9:22 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 7:59 PM
Points: 1,194, Visits: 2,222
D-SQL (4/11/2014)
Trying to create an audit that goes to the application log. With a certain criteria, select, update, delete etc.. where like 'example'-- some criteria

is there any reference out there that could give me some examples?


Thanks in advance


Check these ..

http://technet.microsoft.com/en-us/library/cc280386.aspx -- Check the Target section

http://bradmcgehee.com/2010/03/30/an-introduction-to-sql-server-2008-audit/

--
SQLBuddy

Post #1561519
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse