mssql_audit

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		 Previous revision
mssql_audit [2019/10/17 13:11] – created andonovjmssql_audit [2019/10/18 20:04] (current) – external edit 127.0.0.1
Line 157: Line 157:
 declare @bigintfilter bigint declare @bigintfilter bigint
  
-exec sp_trace_setfilter @TraceID, 1, 0, 6, N'INSERT INTO %G_RISORSE%' +exec sp_trace_setfilter @TraceID, 1, 0, 6, N'INSERT INTO %TABLE_TEST_1%' 
-exec sp_trace_setfilter @TraceID, 1, 1, 6, N'update %G_RISORSE%' +exec sp_trace_setfilter @TraceID, 1, 1, 6, N'update %TABLE_TEST_1%' 
-exec sp_trace_setfilter @TraceID, 1, 1, 6, N'delete %G_RISORSE%' +exec sp_trace_setfilter @TraceID, 1, 1, 6, N'delete %TABLE_TEST_1%' 
-exec sp_trace_setfilter @TraceID, 1, 1, 6, N'INSERT INTO %G_TIMBRATURE%' +exec sp_trace_setfilter @TraceID, 35, 0, 6, N'DATABASE_NAME'
-exec sp_trace_setfilter @TraceID, 1, 1, 6, N'update %G_TIMBRATURE%' +
-exec sp_trace_setfilter @TraceID, 1, 1, 6, N'delete %G_TIMBRATURE%' +
-exec sp_trace_setfilter @TraceID, 35, 0, 6, N'LICO_GROUND'+
 -- Set the trace status to start -- Set the trace status to start
 exec sp_trace_setstatus @TraceID, 1 exec sp_trace_setstatus @TraceID, 1
  • mssql_audit.1571317872.txt.gz
  • Last modified: 2019/10/18 20:04
  • (external edit)