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
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
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
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