Debugging Stored Procedure

I am trying to debug a stored procedure on an SQL Server Database
present on a server. When I use the Debug... option from Sql Query
Analyser, Query nalyser prompts me for parameters for the stored
procedure but when I supply the parameters and hit OK, the stored
procedure simply runs through without giving me a chance to debug. Is
there anything wrong with the installation of Server or client please?Are you using the icons at the top of the debug window that allow you to
control which parts of the code to check?
Jack Vamvas
________________________________________
__________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"John Smith" <postmaster@.sumanthcp.plus.com> wrote in message
news:1139229189.446287.212540@.g44g2000cwa.googlegroups.com...
> I am trying to debug a stored procedure on an SQL Server Database
> present on a server. When I use the Debug... option from Sql Query
> Analyser, Query nalyser prompts me for parameters for the stored
> procedure but when I supply the parameters and hit OK, the stored
> procedure simply runs through without giving me a chance to debug. Is
> there anything wrong with the installation of Server or client please?
>|||Hi,
What edition of SQL 2000 are you using?
I think you should apply a service pack.
"John Smith" wrote:

> I am trying to debug a stored procedure on an SQL Server Database
> present on a server. When I use the Debug... option from Sql Query
> Analyser, Query nalyser prompts me for parameters for the stored
> procedure but when I supply the parameters and hit OK, the stored
> procedure simply runs through without giving me a chance to debug. Is
> there anything wrong with the installation of Server or client please?
>