sql server – server side traces

https://msdn.microsoft.com/en-us/library/cc293613.aspx
start trace – stop trace, then script out file –> export –> script
set InsertFileNameHere and run on server
retrieve data from —
SELECT *
FROM fn_trace_gettable(‘c:inside_sql.trc’, 1)
stop trace and don’t continue —
EXEC sp_trace_setstatus 2, 2

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.