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!
Pallavi

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!
Pallavi

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
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>