Search

Bring Debug Stored Procedure functionality to Management Studio by vrafael

Closed
as Fixed Help for as Fixed

51
1
Sign in
 to vote
Type: Suggestion
ID: 124613
Opened: 10/10/2005 10:47:09 AM
Access Restriction: Public
Duplicates: 127005
0
Workaround(s)
Debuggin Stored Procedures in SQL Server 2005, has changed to be made inside Visual Studio 2005. While this is interesting, debugging procs is also related to Management Studio, where we DBAs will write the majority of scripts and procedures.
Details (expand)
Product Language
English
Version
SQL Server 2005 Community Technology Preview Sep 2005 - Enterprise Edition (32)
Category
Management Tools
Operating System
Other
Operating System Language
US English
Proposed Solution
I think MS should review the possibility to bring Debug funcionality inside Management Studio. Much like the debug is in Query Analyzer. I was expecting to found this in recent releases, but found nothing in September CTP. It could work like the debug in Query Analyzer, you right click the procedure in Object Explorer, and have a Debug or Step Into Proc option. This is would be very handy.
Benefits
Faster Development
Improved User Interface
Improved Administration
Other Benefits
Faster Development
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 3/31/2008 at 9:28 AM
Hi vrafael,

I'm pleased to update you, as well as all the other folks that have so passionately voted for this request, that we have added a T-SQL debugger into management studio. Books Online will have the best overall documentation but a quick synopsis of the functionality includes:

- Arbitrary batch debugging (i.e. no SSMS solution needs to be loaded)
- Debugging over multiple batches in a single debug session
- Debug sprocs, functions, and triggers
- Watch window support for local variables
- Set/Clear breakpoints
- Call stack window support

I look forward to your feedback on the functionality. It will be available in the next release of SQL Server 2008.

Kind regards,
Ken Van Hyning
Posted by Microsoft on 3/30/2006 at 1:56 PM
Quick Update - This functionality is scheduled to go into the next major release of SQL Server.
Posted by Microsoft on 10/11/2005 at 8:20 AM
Thank you for your feedback. We will consider this for the next major release of SQL Server tools.
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement