Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
mssql_audit [2019/10/17 13:12] andonovjmssql_audit [2019/10/18 20:04] (current) – external edit 127.0.0.1
Line 160: Line 160:
 exec sp_trace_setfilter @TraceID, 1, 1, 6, N'update %TABLE_TEST_1%' exec sp_trace_setfilter @TraceID, 1, 1, 6, N'update %TABLE_TEST_1%'
 exec sp_trace_setfilter @TraceID, 1, 1, 6, N'delete %TABLE_TEST_1%' exec sp_trace_setfilter @TraceID, 1, 1, 6, N'delete %TABLE_TEST_1%'
-exec sp_trace_setfilter @TraceID, 35, 0, 6, N'LICO_GROUND'+exec sp_trace_setfilter @TraceID, 35, 0, 6, N'DATABASE_NAME'
 -- 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.1571317925.txt.gz
  • Last modified: 2019/10/18 20:04
  • (external edit)