Stop SQL Server trace using SQL command

Today I started SQL Profiler and paused it. After some time, none of the buttons were enabled. I can neither resume nor stop the trace. Here are the sql commands that I finally found to stop the trace.

Get the trace id

SELECT * FROM ::fn_trace_getinfo(default) WHERE property = 2;

Stop trace

DECLARE @TraceID int
SET @TraceID = ?
EXEC sp_trace_setstatus @TraceID, 0
EXEC sp_trace_setstatus @TraceID, 2

Share

5 comments

Your email address will not be published. Required fields are marked *

  1. Hestabit Technologies says:

    I used this code and it worked perfectly

  2. MAKAROV says:

    Thanks for sharing

  3. ramengo says:

    Thanks. it worked perfctly.

  4. geeks says:

    Humm… interesting,

    works good

    Keep up the good work

  5. Michael B says:

    Many thanks! Worked like a charm.