SQL Server Performance Forum – Threads Archive
How to set Step execution mode in query analyzer?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
Use brakpoints concepts. http://www.15seconds.com/Issue/050106.htm?voteresult=5
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
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.