February 13, 2008 at 1:45 pm
Questions in the header really, can you debug stored procs inside the BIDS environment you get with Sql 2005? When i open up my server explorer and go to sp's i can open/run/delete but there is no "step into". I know i could at my old place but i think a full blown VS was installed on my PC there.
February 13, 2008 at 1:55 pm
From what I have been able to determine, you need the Professional version of Visual Studio or better to debug stored procedures. That was one of my big complaints to Microsoft at a local SQL Server User Group meeting quite a while back. In SQL Server 2000, you could debug a stored proc in Query Analyzer, but we lost the ability to do so in SQL Server Management Studio. My argument was simple, if I can create my stored proc in SSMS, I should also be able to debug it in SSMS. Haven't heard anything about it since, nor have I purchased VS 2005 Professional Edition.
😎
February 13, 2008 at 1:59 pm
Lynn Pettis (2/13/2008)
From what I have been able to determine, you need the Professional version of Visual Studio or better to debug stored procedures. That was one of my big complaints to Microsoft at a local SQL Server User Group meeting quite a while back. In SQL Server 2000, you could debug a stored proc in Query Analyzer, but we lost the ability to do so in SQL Server Management Studio. My argument was simple, if I can create my stored proc in SSMS, I should also be able to debug it in SSMS. Haven't heard anything about it since, nor have I purchased VS 2005 Professional Edition.😎
Well if that is the case (and it does seem to be) then i completely agree with you in raising this with MS. The only other way i can seem to debug SPs is by putting a million and one print statement in and using a rollback at the end. :crazy:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply