debugging SQL stored procedure

Hi

I have a simple windows application which uses two stored procedures at the backend to fetch the data and display it in the grid of UI

I wanted to debug these stored procedures line by line like using run time storage dump for various variable and statements used in the procedures as we do it in Visual studio using functional keys etc.

or

Any way to do this using SQL server 2000 query analyzer? The stored procedures contains nearly five hundred lines of code in sql.

Early reply is much appreciated.

Thanks!

In query analyzer, show object browser. then select your stored proc, and right click.

Select debug.

For more, look at this article http://www.15seconds.com/Issue/050106.htm

|||

Thanks for your help. This debug option is not available in sql2k5. I do not see any debug option available for sql2k5 when I right click the stored proc. Is there any option to do in sql2k5?

Thanks!

Santhosh