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
