Debugging | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


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.,39026552,39258077,00.htm;en-us;280101 Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.