SQL Server 2005 debug a stored procedure, how-to?
If you are Developer then debugging your own code is an usual practice and when you got used to perform the same on SQL Server 2000 version, it is not an easy way in SQL Server 2005 version.
As you may be aware that SQL Server
2000 engine includes a debugger for stored procedures and not within SQL Server 2005. The alternative to this process it to use Visual Studio. This means either extra costs or
decreased productivity for developers who don't need Visual Studio for any other
reason that to be able to debug stored procedures and further information on this MSDN article.
Micorosft development team is looking to implement a better way within SQL Server 2008 and as of now 2005 is only way out with Visual Studio.