testing sql server 2005 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

testing sql server 2005

Author

Topic

jassie
Constraint Violating Yak Guru

332 Posts

Posted - 2010-09-02 : 08:44:44

I would like to know how to debug stored procedures from sql server management studio. I basically would like to know how to 'step though' or debug a stoed proceudre.

MSquared
Yak Posting Veteran

52 Posts

Posted - 2010-09-09 : 12:31:35

You can't in SQL 2005. You can put print statements in you code, but the interface doesn't allow to step through the procs. SQL 2008 SSMS does

For Faster results please follow the posting guidelines here

http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources