New answers tagged audit
The SQL Server Audit feature provides more details about the SQL Server instance and database events than the Change Tracking and Change Data Capture features - these do not track executed queries. The feature provides the information about who, what and when, and enables granular filtering of the audited events. It also tracks execution of the SELECT ...
In SQL Server 2012, the Create Audit dialog enables to specify the audit files size and number. You cannot specify the time the times are saved, but the file size and number might be enough to accomplish what you're looking for Maximum rollover files - the number of files kept in the system. When the maximum number is reached, the new files overwrite the ...
Sorry to be responding to something so old... http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5044a52c-f09b-4ac2-8a85-df627e677c33/how-to-trace-to-see-if-a-linked-server-is-being-used?forum=sqldatabaseengine Seems pretty straightforward. I'm going to be using trace to audit this... will update with my solution.
I have found a way to prevent duplicate rows in FGA audit trail with parallel query First create a function that return 1 if AUTHENTICATION_METHOD is PQ_SLAVE in USERENV context (coordinator process gets 0) create or replace function is_pg_slave return integer as begin if (sys_context('USERENV', 'AUTHENTICATION_METHOD') = 'PQ_SLAVE') then return 1; ...
Top 50 recent answers are included