Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dan Guzman Stairway to Server-side Tracing - Step 2: Creating a SQL Trace Using T-SQL (Stairway Series) RE: Stairway to Server-side Tracing - Step 2: Creating a SQL Trace Using T-SQL (Stairway Series)

  • February 21, 2011 at 4:08 am

    #1289342

    I copied the script used to list all possible trace events and columns and executed on my sql server 2005 SP3 system. It returns only 14 rows (in other words not all possible categories - )

    Is there something I am missing here?

    The categories returned are:

    Locks

    Scans

    Security Audit

    Stored Procedures

    Transactions

    TSQL

    Thanks for your help.