SQL Server Performance

Debugging Stored Procedures

Discussion in 'SQL Server 2005 General Developer Questions' started by benwilson, May 7, 2006.

  1. benwilson New Member

    Hi All,
    Just wondering if Management Studio offers the ability to debug stored procedures (like in Query Analyser). I have had a look in help and through the menus and i cant seem to find equivalent functionality!

    Thanks in advance,
    Ben

    'I reject your reality and substitute my own' - Adam Savage
  2. satya Moderator

    http://sqljunkies.com/WebLog/nielsb/archive/2004/08/04/3758.aspx

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. vbkenya New Member

    SQL Server Management Studio does not include a debugger. So all debugging has to be done using Visual Studio.


    Nathan H. Omukwenyi
    MVP [SQL Server]
  4. benwilson New Member

    Thanks for the info guys!

    but, wow! What a step backwards! Taking the debugger out of the SQL Server really makes a lot of sense to me [insert sarcasm here].

    Ben

    'I reject your reality and substitute my own' - Adam Savage
  5. Adriaan New Member

    I'm curious as well - the linked blog discusses debugging CLR, so has SQL 2005 lost the ability to step through T-SQL sprocs, UDFs and triggers?

    There were a couple of things to be improved in SQL 2000's debugging, but at least it was straight, clean and simple - right-click in QA and off you went.

    By the way - just to show off my ignorance all over again - does SQL 2005 even have a tool like QA?
  6. SQL_Guess New Member

    Sadly, Adriaan that seems to be true. I cannot find any reference, in BOL, forums, or the SQL Server Management Studio to doing T-SQL stored procedure debugging. That's a really bad decision - now I have to try and get VSS to open my SQL Solution to debug it? My VSS seems to know about Integreation Services, Analysis Services and Reporting Services, but not SQL. Do I need to install a component to get VSS to open SQL projects and debug them? AAAARGH

    Panic, Chaos, Disorder ... my work here is done --unknown
  7. Adriaan New Member

    What is even worse is that the debugger has stopped functioning recently - not sure if it was caused by SP4.

    Anyone with the same experience?
  8. SQL_Guess New Member

    hmm - fortunately ( or unfortunately, depending on your point-of-view) I've gone from SQL2000sp3a (previous company) straight to SQL2005sp1, so I can't help, other than to offer my commiserations.

    Panic, Chaos, Disorder ... my work here is done --unknown

Share This Page