Debugging stored procedure in SQL Server 2005?

I want to debug SQL stored-procedure.How I do? My current database system SQL Server 2005 and the editors of VS 2005 and VS 2003. I can not see the debug option in VS2005 for db Stored_procedure or anything while in other cases in which VS2003 is available work does not show the following error "Unable to start debugging SQL sqldbreg2.exe session.Ensure and proxy / stub DLL sqldbg.dll registered on this machine. "Let me know how to fix this.

At first registering the dll with regsvr32, and then run the exe file or include it in your project. Of all ways to debug a stored procedure is easier when you use SQL Query Analyzer, a set sometime in the print command to be see the output of Helmut

GTAC 2010: Lightning Talks – Day 1