SQL Server Performance

How to set Step execution mode in query analyzer?

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by jsriveeru, Feb 11, 2007.

  1. jsriveeru New Member

    Hi thanks,

    I want to debug a stored procedure.I opened object browser and set all the parameters after opening specific sp in Debug mode.It is executed entirely.

    Problem:It is not stopped at begining of sp.I think the problem is with step execution mode setting.

    Please tell me how to trace sp in step by step.

    Thanks&Regards
    Veeru
    jsriveeru, Feb 11, 2007
    #2

  2. rao New Member

    rao, Feb 11, 2007
    #2

  3. madhuottapalam New Member

    madhuottapalam, Feb 11, 2007
    #2

  4. satya Moderator

    In order to setup trace step by step SQL Server books online is best resource for you to go through the required information.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
    satya, Feb 12, 2007
    #2

Share This Page