SQL Server Performance Forum – Threads Archive

Debugging

I want to debug a Stored Procedure. I know the basic steps to debug a Stored Procedure. But when i tried to bebug i cannot proceed step by step. It execute in a go. I cannot examine the result after each step. I also tried to insert breakpoint but that too didnot worked. Can anyone help me

Check whether any nested statements are used. http://uk.builder.com/architecture/db/0,39026552,39258077,00.htm
http://www.15seconds.com/issue/050106.htm
http://support.microsoft.com/?kbid=837221
http://support.microsoft.com/default.aspx?scid=kb;en-us;280101 Satya SKJ
Microsoft SQL Server MVP
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.

]]>