HOW TO READ MSSQL TRACE?

 GO


DECLARE @tracefile VARCHAR(500)

-- Get path of default trace file

SELECT @tracefile = CAST(value AS VARCHAR(500))

FROM ::fn_trace_getinfo(DEFAULT)

WHERE traceid = 1

AND property = 2


PRINT @tracefile

-- Get security changes from the default trace

SELECT *

FROM ::fn_trace_gettable(@tracefile, DEFAULT) trcdata -- DEFAULT means all trace files will be read

INNER JOIN sys.trace_events evt ON trcdata.EventClass = evt.trace_event_id

WHERE trcdata.EventClass IN (102, 103, 104, 105, 106, 108, 109, 110, 111)

ORDER BY trcdata.StartTime


Comments

  1. You should be guaranteed that every one of the eyes will be on you,Escorts whatsapp number in Ahmedabad once you go out with an Housewife Call Girls in Ahmedabad. Their luxurious body, snappy facial,Gurgaon Russian Escorts and also a supreme method for getting dressed make every one of Local Escorts Service in Goa the heads turn towards you.Local Escorts Service in Goa This is the main cause of why we afford tremendously hot erotic sex services in Gurgaon.Escorts Agency in Dehradun These escorts faces, & hot figure are really very eye-catching.

    ReplyDelete

Post a Comment

Popular posts from this blog

What is Aws?

Introduction to Agile development