What is "SQL Trace ID 2"

Discussion in 'microsoft.public.sqlserver.server' started by Pranil, Feb 24, 2006.

  1. Pranil

    Pranil Guest

    My SQL 2005 log is full of SQL Trace ID 2 getting started and stopped, the
    logins are user logins as well as sql exec account login (used to start jobs).
    eg:
    SQL Trace ID 2 was started by login "XXX\XXXXX".Error: 19099,
    Severity: 16, State: 1.
    Trace ID '2' was stopped because of an error. Cause: 0x800704c7(The
    operation was canceled by the user.). Restart the trace after correcting the
    problem.

    What does this trace do and what causes it to be activated ?
     
    Pranil, Feb 24, 2006
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.