SMSS Debugging Stored Procedure

I am trying to find a way, either through VS or using SMSS, to debug a stored procedure. I can use print statements, etc. but I am trying to use real debugging methods. Breakpoints, Step into, etc. Notes: I have all versions of SMSS and VS and the DB is on a 2005 SQL server, no linked servers.

I have followed a number of  google articles and am getting more frustrated. Any help would be appreciated.

Thanks. LK
ljkraussAsked:
Who is Participating?
 
bull_riderCommented:
Please go through the below link:

http://www.dotnetfunda.com/articles/article27.aspx

Let me know if it does not work. And finally what is the edition of VS and SQL Server 2005?
0
 
ljkraussAuthor Commented:

bull_rider: this will take some time... Ill try this evening...

radceasar: i tried this from VS 2010 and got:
Successfully attached these types of code: Managed (2.0....)

Failed to attach TSQL. Operation Aborted.

Everything seeemed the same as in the instructions so I didnt think it was an issue with the VS version - though the web page doesnt include 2010 under versions where other similar pages do. I dont have VS 2008 installed at the moment....

0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
Alpesh PatelAssistant ConsultantCommented:
Hi,

There is a Debugger is available. Put break points on code and debug it. tst tst
0
 
ljkraussAuthor Commented:
Sorry for not following up on this item. We have recently set up a large 2008 R2 cluster and been migrating apps over. Frankly I dont remember the  details of not being able to get the debugger working on SQL 2005 but I believe it was something to do with a Security issue on that particular SQL server. Thanks to all of those that commented.
0
 
ljkraussAuthor Commented:
Any partial solution was due to my lack of followup not those trying to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.