September 18, 2006 at 10:02 am
It is possible to debug Transact-SQL stored procedures on SQL Server 2000 using Query Analyzer.
I can not find the similar ability in SQL Server 2005.
Does anybody know anything about it?
Igor Birioukov
September 18, 2006 at 10:19 am
Yes,
In QA Open the Object browser
Tools --> Object Browser --> Show/Hide.
Locate the stored procedure in db you want, Rightclick, Select Debug.
Enter parameters if required.
Not perfect, but works
September 18, 2006 at 10:44 am
This is souds like QA for SQL 2000. It does not work for SQL 2005, at least for me.
Igor Birioukov
September 18, 2006 at 11:22 am
Currently you can't debug a stored procedure using SSMS. At this time you have to have Visual Studio Professional or better to accomplish this very useful feat. Personally, if you can create the stored procedure in SSMS you should be able to debug it in SSMS.
When our SQL Server User group had Microsoft at one of our meetings, I brought this up. Supposedly they are going to restore the debug capability back into SSMS, but only Microsoft knows for sure when that will happen, and if it actually will.
September 18, 2006 at 11:32 am
Lynn,
Thank you very much. That is exactly what I suspected.
Igor Birioukov
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply