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
  2. rao New Member

  3. madhuottapalam New Member

  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.

Share This Page