can you execute SQL sp's from SQL to debug?

[Steve Thomas]

Can you execute stored procedures from within SQL server to see how they perform?

[Clunietp]

If you mean you want to see them perform step by step, you can use the T-SQL debugger add-in with VB. If you want to do it via the Enterprise manager or SQL Query analyzer, you just call it as normal....