Dubugging the Procedure | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Dubugging the Procedure

Hi All, Does anyone know how to debug a stored procedure in SQL 2000. I have a procedure which adds recrods in a table and I want to check the change in the values of a varibale throughout the procedure. Kindly write with your comments and suggestions. Warm Regards!
In Query Analyser hit F8. Then select that sp;right click and select Debug Madhivanan Failing to plan is Planning to fail
Thanks for the reply. Warm Regards!
http://msdn.microsoft.com/library/en-us/vsdebug/html/vxtskasqldebuggingexample.asp andhttp://techrepublic.com.com/5208-9592-0.html?forumID=88&threadID=177211&start=0 fyi. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.