SMSS Debugging Stored Procedure

Posted on 2011-04-26
Last Modified: 2012-05-11
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
Question by:ljkrauss
    LVL 6

    Accepted Solution

    Please go through the below link:

    Let me know if it does not work. And finally what is the edition of VS and SQL Server 2005?
    LVL 9

    Assisted Solution


    Author Comment


    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....

    LVL 21

    Assisted Solution

    by:Alpesh Patel

    There is a Debugger is available. Put break points on code and debug it. tst tst

    Author Comment

    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.

    Author Closing Comment

    Any partial solution was due to my lack of followup not those trying to help.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now