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
 Transact-SQL (2005)
 How to troubleshoot on Stored proc?

Author  Topic 

getur.srikanth@gmail.com
Yak Posting Veteran

77 Posts
Posted - 2008-02-21 : 12:21:00

How can we do troubleshoot on stored proc ? Is there any easy way to do that?.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2008-02-21 : 12:31:12
You can make use of SQL Profiler to debug store procedures.

http://www.microsoft.com/technet/prodtechnol/sql/70/tips/sqlprof.mspx

You can also debug your store procedure using Visual Studio

http://www.sqlteam.com/article/debugging-stored-procedures-in-visual-studio-2005

Another crude way is to use PRINT/SELECT satements in between query batches to check intermediate results.
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site