Post reply

sql server profiler running trace

  • November 24, 2011 at 9:08 am

    #260590

    we have discovered a trace that sombody else has started, however the trace cannot be stopped, as the option is grayed out on the file menu, how can we stop this through SQL

    Thanks:-)

  • November 24, 2011 at 9:11 am

    #1412742

    File menu?

    You can alter the statuses of traces with sp_trace_setstatus (I think that's where the _ are). See Books Online for details, I can never remember the parameters offhand.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 24, 2011 at 9:19 am

    #1412747

    IIRC 0 stops, 2 deletes the trace definition.

    Takes both commands to completely eliminate the trace from the system.

    Why don't you find the person who started it and ask him to spot it assuming he has no reason to keep it going?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply