• Server-side traces (sp_create_trace) and traceflags (DBCC traceon) are completely different concepts.

    Server-side traces are essentially profiler traces without the GUI, they log when events occur on the instance being traced, such as login failures, stored procedure executions, errors, etc. You can use the profiler GUI to generate the script to create the trace for you.

    Traceflags can be enabled or disabled (there are lots and lots of different traceflags) and they change certain aspects of SQL's behaviour.

    For server-side traces, try a google search. Lots of information turns up with a simple search.

    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