sql server – server side traces

start trace – stop trace, then script out file –> export –> script
set InsertFileNameHere and run on server
retrieve data from —
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. Required fields are marked *

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