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)

  • September 13, 2012 at 12:10 am

    #1537025

    Hey

    If you didn't remove the line:

    DECLARE @TraceID INT;

    You are declaring it, so I would check for misspellings, left out lines, or if you do a GO inbetween

    /Jon

    DBA_Learner (9/12/2012)

    I am following the same way as in script..but receiving the folowing error on Step 2:

    Must declare the scalar variable "@TraceID".

    Any suggestions..do we need to declare any traceid value