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 2000 Forums
 SQL Server Development (2000)
 Setting up SQL Server for debugging Stored Procedures and Functions

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-07-22 : 08:12:50
Marc Cudden writes "How do you set up your SQL Server 2000 for debugging stored procedures and functions? I use stored procedures for all my business logic as I have applications used for both VB and ASP using the same stored procedures. It is much better and easily more maintainable for me to do it all in stored procedures and functions. I used the PRINT statement in stored procedures, but the functions will not allow this, besides I want to be able to track values throughout the execution. Thanks"

M.E.
Aged Yak Warrior

539 Posts

Posted - 2002-07-22 : 10:00:05
Look up Raiserror in books online.

-----------------------
Take my advice, I dare ya
Go to Top of Page
   

- Advertisement -