Post reply

Debuging T-SQL stored procedure

  • June 15, 2005 at 12:43 am

    #66289

    Hi,

    How can I debug T-SQL stored procedure in SQL 2005 April CTP?

    Thanks for any suggestion.

  • June 20, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • May 24, 2006 at 9:15 am

    #639826

    I installed the old SQL2000 tools including Query Analyzer.  However I cannot get debugging to work on a simple tsql procedure.

    This is a MAJOR flaw with SQL2005.  Who wants to install something on a QA/staging server that is not going to be on a production server, to troubleshoot?  There are many times that the QA staff will step through code with Query analyzer to assist in the resolution to the issue.  They will not be able to do so now, since we want the QA/staging environment the same as production.  And we are not about to install the IDE on production.

     

    So the list of useful missing items is increased by one:

    ·       Taskpad

    ·        Ability to quickly script permissions on stored procedures

    ·        Ability to quickly see disk space in database properties

    ·        Time of creation of stored procedures

    ·        Debug TSQL stored procedures

    [font="Arial"]Clifton G. Collins III[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply