June 23, 2009 at 2:50 am
Hi,
is there any editor present for sql server which will give me the line by line debugging facility like VB6.0 editor?
It should show all the details, variable names and their values like VB editor.
June 23, 2009 at 3:15 am
Its certainly not as easy as it was in SQL2000
In theory, Open SQL Server Business Intelligence Studio (aka Visual Studio .NET 2005) Create a database connection, right-click on the stored procedure you want to step through and select "Step-Into"
However, you may find the "Step-Into" option isn't there.
check this Microsoft KB http://support.microsoft.com/kb/817178 as any number of things could need tweaking to get it working.
June 23, 2009 at 4:19 am
Hi Tom,
Thanks for your reply.
Is there any third party editor, which can serve my purpose?
Debugging the SP is really a tough job to me :w00t:
Thanks in advance.
June 23, 2009 at 5:15 am
I don;t know of any in SQL 2005. - did you try Googling? Otherwise I think you can download a trial version of visual studio 2005 and get 90 days free.
They included debugging as part of SQL 2008, so you don't need visual studio for debugging on that version.
June 28, 2009 at 9:04 pm
I believe that you have to have Visual Studion 2005 Professional or better to debug stored procedures in SQL Server 2005. And yes, I have heard that they have brought back that capability in SQL Server 2008. Why they took it away in the first place boogles the mind.
June 29, 2009 at 4:39 am
Hi,
I am trying as per the MS KB 316549. But as per tony's first response,
I am not able to find out the "step into stored procedure" while testing.
What is the way out? How to debug? Why this option is not coming?
Is it something like that i should have VS professional?
June 29, 2009 at 5:04 am
Yes, you need VS 2005 professional.
You can't debug from Sql Server Management Studio (the way you could from Query Analyser)
In Visual Studio 2005:
open Server Explorer (CTRL+ALT+S)
create a new data connection
navigate to the Stored Procedure you want to debug
Right-click, select "Step Into Stored Procedure"
you can drag and drop your @param variables into the watch window
If it doesnt work, then you follow the instructions in the KB article http://support.microsoft.com/kb/817178%5B/url%5D
June 29, 2009 at 5:09 am
Thanks Tom,
A really needful post.
The thing now I need to install VS 2005 Professional 🙁
Any suggestion, if I use VS 2003, can i have feature? or is it only available in VS 2005 professional?
June 29, 2009 at 5:26 am
Not 2003, It Has to be 2005, as the feature came with the closer association with VS2005 and SQL2005.
When you install SQL2005 - you can install something called "Business Intelligence Studio" - which is a version of Visual Studio 2005, but with features for SQL, i.e. the debugger, the SSIS designer, etc. So If you still have the installer for SQL2005, you could try that
http://msdn.microsoft.com/en-us/library/ms173767(SQL.90).aspx
June 29, 2009 at 6:08 am
Hi Tom,
I have tested with Business Intelligence studio 2005 which comes along with SQL Server 2005...still that option is not coming.
Probably that comes with only VS 2005.
Anyway, thanks a ton for your help.
June 30, 2009 at 9:21 am
I think Toad for SQL Server may have this functionality. I use Toad, but haven't tried the debugger. It has some great features, including multiple sets of query results, easy to use code snippets, and a cool data compare model.
http://www.toadsoft.com/toadsqlserver/toad_sqlserver.htm
They have a free version, and they are currently in a Beta cycle which gives you access to more than you get in the free version.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply