Stepping thru a Stored Procedure in | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Stepping thru a Stored Procedure in

Hello 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).
Thank you.
Stephen

Check the permission for that user, first thing.
Article on performing such tasks in SQL 2005.
Blog post too.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |