how to debug stored procedure?
Using SQL Query Analyzer, You can debug a stored procedure.
By running the SQL Server profiler.