daily pastebin goal
58%
SHARE
TWEET

Untitled

a guest Dec 7th, 2017 49 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DECLARE @tracefile VARCHAR(256)
  2. SELECT @tracefile = CAST(value AS VARCHAR(256))
  3. FROM ::fn_trace_getinfo(DEFAULT)
  4. WHERE traceid = 1
  5. AND property = 2 -- filename property
  6.  
  7. SELECT *
  8. FROM ::fn_trace_gettable(@tracefile, DEFAULT) trc
  9. INNER JOIN sys.trace_events evt ON trc.EventClass = evt.trace_event_id
  10. WHERE trc.EventClass IN (102, 103, 104, 105, 106, 108, 109, 110, 111)
  11. ORDER BY trc.StartTime
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top