Wednesday, July 24, 2013

View SQL Server Trace

To view a specific SQL trace, use fn_trace_getinfo and specify the ID of the trace

 SELECT *_
FROM ::fn_trace_getinfo(trace_id)

For this option, you would have to know the trace ID

Another option, which I find more user friendly is simply by opening SQL Server Profiler and selecting a specific file trace