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
No comments:
Post a Comment