SQL Server Performance

Tools for debug store procedure

Discussion in 'SQL Server 2005 General Developer Questions' started by yhchan2005, Sep 12, 2010.

  1. yhchan2005 Member

    Hi,
    i am looking for some tools which can debug the store procedure which similiar to debug program source code. i am not using visual studio and would like to know whether any 3rd party tools to do it.
    thanks.
  2. ghemant Moderator

    If you use SQL Server 2008 Management Studio you can see a menu called "Debug" which you can use to debug the stored procedure, though not sure if it will the same way with SQL Server 2005 as it works on SQL Server 2008.
  3. dineshasanka Moderator

    you can use apex debug
    http://www.apexsql.com/sql_tools_debug.aspx
    http://dbfriend.blogspot.com/2009/02/integrating-perfmon-and-profiler.html
  4. satya Moderator

    Hemant, in SQL 2005 is totally disabled from SQL tools and in this case what Dinesh is referred is correct for the OP's point of view in using third party tools.

Share This Page