Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rudesyle
Posting Yak Master
110 Posts |
 Posted - 2007-10-30 : 10:52:06
|
| The only way I know of to debug a Sql 2005 stored proc is to create a VS2005 Database Project and step into it from there. Does anyone know of any third party tools that adds functionality to Sql Management Studio to step into stored procs? |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-30 : 11:21:22
|
I use PRINT and SELECT to debug mine  |
 |
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2007-10-30 : 12:44:56
|
| Don't forget RAISERROR! :) |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-30 : 12:50:22
|
| no. there are none._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
rudesyle
Posting Yak Master
110 Posts |
Posted - 2007-10-30 : 12:51:17
|
quote:
Originally posted by Kristen
I use PRINT and SELECT to debug mine
Yes, Old School is very reliable. But it does suck that directly stepping into a stored proc disappeared with Sql 2005 |
|
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2007-10-30 : 13:00:10
|
| It barely worked in 2000 (native debugging via Query Analyzer) and you sure as heck didn't turn it on in production... Under those circumstances, I pretty much dropped it and use the old-skool methods. |
|
|
|
|
|
|
Third party tools that add sp debugging