3
Votes

Debugging SQL Server 2005 Stored Procedures in Visual Studio

published 1827 days, 19 hours, 19 minutes ago posted by RajaSekharRajaSekhar 1830 days, 20 hours, 23 minutes ago
Wednesday, July 29, 2009 8:00:00 AM GMT Sunday, July 26, 2009 6:55:45 AM GMT

With Microsoft SQL Server 2000 it was possible to debug stored procedures from directly within Query Analyzer (see Debugging a SQL Stored Procedure from inside SQL Server 2000 Query Analyzer for more information). With SQL Server 2005, however, this functionality was moved out of SQL Server Management Studio and into the Visual Studio IDE. Using this technique, it is possible to step into your stored procedures, one statement at a time, from within Visual Studio. It is also possible to set breakpoints within your stored procedures' statements and have these breakpoints hit when debugging your application.

Category: Technology | Clicked: 4 | | Source: aspnet.4guysfromrolla.com | show counter code
Tags: Debugging, SQL Server 2005, Stored Procedures

No comments yet, be the first one to post comment.

To post your comment please login or signup