stored procedure debug

[toryee]

Hi,
I have a stored procedure in Microsoft sql server, and it is called from Microsoft Access VBA code. Is there a way to step through the stored procedure and check of the result returned by the each sql statement? I have Microsoft SQL Server Enterprise Manager 8.0 and SQL Query Analyzer 8.0.
Thanks for any help.

 

[sbphelps]

In Query Analyzer's Object browser, expand the database, stored procedures, and right click on the stored procedure you wish to debug. select "debug..." from the pop-up menu.


sbphelps