Very Computer

Is anyone aware of a SQL development tool that allows debugging of compiled
stored procedures?  So far I have looked at RapidSQL by Embarcadero, and
although it is a great tool to work with, it only debugs source code,
without the benefit of real live parameters in an execution environment.
What I want to do is be able to execute a stored procedure line by line, and
be able to examine the value of variables, determine the outcome of
conditional statements as they are executed, etc.  De*s such as this
are common in 3GL and 4GL tools, but I haven't found any that can do
likewise for SQL Server.

Glenn,

Quote:> Is anyone aware of a SQL development tool that allows debugging of compiled
> stored procedures?  So far I have looked at RapidSQL by Embarcadero, and

Q.  What tools are available to debug stored-procedures under SQL Server?
(v1.0  3.12.1998)

A.  By no means an exhaustive list - product/vendor/www where known.

Microsoft's Visual Basic and Visual C Enterprise Edition contain built-in
stored-procedure debugging code.

Also

www.embarcadero.com - RapidSQL
www.sigmaweb.com - SP_De*
www.castsoftware.com
www.compuware.com - Xpediter
www.sfi-software.com - SQL Programmer

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)
 For SQL FAQ entries see www.ntfaq.com/sql.html
 and http://www.veryComputer.com/
 and GO MSSQL Lib 1 on Compuserve

You might take a look on MS Visual InterDev - although I can't guarantee
that you cann do everything you want with it. But it's woth a try anyway
cause it's a very nice program.