Stepping thru a Stored Procedure in | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Stepping thru a Stored Procedure inHello All
Thanks for the previous replies.
Since upgrading from 2000 to 2005.
I cannot figure out how to step thru a SP, breakpoints, etc.
The insert breakpoint, right click, menu option is disables in the Visual Studio suplied with 2005.
In 2000, I could step 1 line at a time, in Query Analyser.
(I want to step thru just like the SP was a pice of code in e.g. FoxPro, C sharp).
Check the permission for that user, first thing.
Article on performing such tasks in SQL 2005.
Blog post too.