Software needed to Debug Stored Procedures

[AccessSQLUser]

What software is needed to debug SQL Server stored procedures? Can other software be used besides VB Enterprise edition?

 

[Cagliostro]

Maybe SQLServer Profiler will help. In can do something what look like a debug. John Fill

ivfmd@mail.md

 

[tlbroadbent]

SQL Profiler can certainly help but doesn't allow you to step through a SP. You can debug in SQL Server 2000 Query Analyzer, Visual C++, Visual Basic Enterprise Edition, SQL Workshop 3.0 From Analytical Solutions, Inc. and a host of other products.

I actually do most of my debugging in SQL Server 7 Query Analyzer.
Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot

 

[AccessSQLUser]

You can step through code in Query Analyzer. I would like a program where I can set breakpoints and step through the code.