Monday, June 4, 2012

Debugging sql stored procedure

Steps to debug t-sql in sql server 2005
  • open visual studio 2008
  • open new project database under other project types
  • choose database reference
  • open server explorer
  • connect to the datase
  • expand the stored procedure to debug stored procedure
  • right click the stored procedure and click "Step into stored procedure" in context menu
  • provide necessary parameters for stored procedure
  • click F10 to step through and F11 to step into (if it calls anther stored procedure) stored procedure

No comments:

Post a Comment