March 13, 2009 at 6:24 am
Hi All,
How do I debug SP from management studio 2005?
Thanks.
March 13, 2009 at 6:34 am
You can put 'print' commands in SP, run SP and watch for output (in Management Studio)
Or use xp_logevent in SP for writing to eventlog
Or insert data inside of SP into some tables and then look at those tables
...
March 13, 2009 at 6:36 am
Simon,
I have done all of that, but is there a way to debug right into the SP from ssms?
Thanks.
March 13, 2009 at 6:38 am
When you are running the 2008 tools against a 2008 instance you can.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 13, 2009 at 6:41 am
I think you can use breakpoints in SQL Server 2008.
In 2005, no.
March 13, 2009 at 6:52 am
So I take it that there is no way to debug in 2005.
March 15, 2009 at 1:47 pm
You can do this in SQL Server BI Dev Studio for certain; haven't done it in SSMS (don't think it is possible in SSMS).
March 17, 2009 at 4:32 pm
You can debug stored procs but you MUST have the right version of Visual studio and I believe its the standard or professional version. The out of the box SQL EM does not allow you to do this. I think it stinks, but that's the way it is.
These forum posts may help.
http://msdn.microsoft.com/en-us/library/yet1b7by(VS.80).aspx
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply