Halt audit trace if audit file doesn’t rollover
I have a security requirement for SQL Server 2005 and 2008: “SQL Server shall be configured to halt if a failure in audit file rollover occurs”. How do I accomplish this?

Answer Question   |  March 31, 2012  4:59 PM
Audit File Rollover, Audit Trace, SQL audit, SQL Security, SQL Server 2005, SQL Server 2008

MSQL Auditing
Hello. I’m dot.net developer, and i’m working a lot with MSQL. My current task is when some user executes select query on database, i should ”catch” the query data. What do i mean is if select query is “select * from UsersTbl where UserID = 5″, i have to get  ’5′. Does somebody have any idea where to start??? Thanks [...]

Answer Question   |  April 9, 2011  8:25 AM
Auditing, dot.net, MySQL, MySQL query, SQL, SQL audit, SQL Query

Exclude Login from SQL Audit Trace
I’m working on a stored procedure to capture SQL Server 2005 Audit events.  There is an Application login/user that generates a LOT of rows because it is constatntly hitting the database. I’m using something like: exec sp_trace_setevent @TraceID, 14, 11, @on How do I EXCLUDE a specific login from being audited?

Answer Question   |  August 16, 2010  6:06 PM
Audit Trace, SQL audit, SQL Server, SQL Server 2005, SQL stored procedures

Auditing users of STRSQL
I want to audit the SQL statements of users who use STRSQL. I know if you press F13, you can change the interactive SQL Session Services. If you choose option 4 it will save all SQL statements into a file. But I was wondering if it is possible if we setup this as default when [...]

Answer Question   |  February 18, 2010  9:02 PM
SQL, SQL audit, STRSQL