Debug Stored-procedure In Sql Server 2005?
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.
Related Posts:
Tags: 2005 | Debug | Server | Storedprocedure
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
1 Response to “Debug Stored-procedure In Sql Server 2005?”.
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
Leave a comment.