SQL Server Performance

debugging sql server 2005 database

Discussion in 'SQL Server 2005 General Developer Questions' started by jassie, Sep 17, 2010.

  1. jassie New Member

    I would like to know how to 'step through' sql in a stored procedure in a sql server 2005 standard edition database. I would be using visual studio.net 2008 professional version to step through the code.
  2. ashish287 New Member

    it is available in sql 2008 onwards but not in 2005.
    But you can use the print command and variables after every line where you want to see the result for debugging the SP.
  3. satya Moderator

Share This Page