Debug stored-procedure in SQL Server 2005?

Question

I want to to debug SQL Stored-procedure.How do I do that??
My current system Database SQL 2005 and Editors VS 2005 and VS 2003. I can't to see Debug option in VS2005 for Stored_procedure or any other db objects where as in case VS2003 where it is available it doesn't work shows following error "Unable to start SQL debug session.Ensure sqldbreg2.exe and proxy/stub DLL sqldbg.dll are registered on this machine."
Let me know how to solve this.

Answer 1

At first you register the dll with regsvr32 and then you run the exe file or include it in your project.
Anyway to debug a stored procedure is easier when you use SQL Query Analyzer an set at some point the print command so that you can see the output

Helmut