Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @tracefile VARCHAR(256)
- SELECT @tracefile = CAST(value AS VARCHAR(256))
- FROM ::fn_trace_getinfo(DEFAULT)
- WHERE traceid = 1
- AND property = 2 -- filename property
- SELECT *
- FROM ::fn_trace_gettable(@tracefile, DEFAULT) trc
- INNER JOIN sys.trace_events evt ON trc.EventClass = evt.trace_event_id
- WHERE trc.EventClass IN (102, 103, 104, 105, 106, 108, 109, 110, 111)
- ORDER BY trc.StartTime
Add Comment
Please, Sign In to add comment