Very Computer

Hi,

I am using ms sql 7.0 and currently having a problem when want to debug a
stored procedure.
can anyone tell me any de* tool available from microsoft or any 3rd
party?

Thanks in advance.

Quote:> I am using ms sql 7.0 and currently having a problem when want to debug a
> stored procedure.
> can anyone tell me any de* tool available from microsoft or any 3rd
> party?

A.  Microsoft's Visual Basic and Visual C Enterprise Edition contain built-in
stored-procedure debugging code for SQL 6.5 and 7.0.  See  
http://www.veryComputer.com/
for details on how to configure it.

With SQL 2000 the de* is also integrated into the query analyzer tool so
that you do not need to use an external development tool.

There are also 3rd-party products available, including :-

http://www.veryComputer.com/ - RapidSQL
http://www.veryComputer.com/ - SQL-Builder
http://www.veryComputer.com/ - Xpediter
http://www.veryComputer.com/ - SQL Programmer

===

v1.03 2000.05.25
Applies to SQL Server versions  : All
FAQ Categories                  : Application Design and Programming
Related FAQ articles            : n/a
Related Microsoft Kb articles   : Try also Q170496 "INF: Tips for Debugging
Stored Procedures from Visual Basic"
Other related information       : n/a
Authors                         : Neil Pike

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (faqrtf.zip - L7
- SQL Public)
 or    http://www.veryComputer.com/
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq

http://www.veryComputer.com/
htm

Beware - setting up SQL debugging will not be easy! There are many
things that can go wrong.

Quote:> for details on how to configure it.

> With SQL 2000 the de* is also integrated into the query analyzer
tool so
> that you do not need to use an external development tool.

> There are also 3rd-party products available, including :-

> http://www.veryComputer.com/ - RapidSQL
> http://www.veryComputer.com/ - SQL-Builder
> http://www.veryComputer.com/ - Xpediter
> http://www.veryComputer.com/ - SQL Programmer

> ===

> v1.03 2000.05.25
> Applies to SQL Server versions  : All
> FAQ Categories                  : Application Design and Programming
> Related FAQ articles            : n/a
> Related Microsoft Kb articles   : Try also Q170496 "INF: Tips for
Debugging
> Stored Procedures from Visual Basic"
> Other related information       : n/a
> Authors                         : Neil Pike

>  Neil Pike MVP/MCSE.  Protech Computing Ltd
>  Reply here - no email
>  SQL FAQ (484 entries) see
>  forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqrtf.zip - L7
> - SQL Public)
>  or    http://www.veryComputer.com/
>  or www.sqlserverfaq.com
>  or www.mssqlserver.com/faq