4GuysFromRolla is offering a nice walk through of getting up and debugging with SQL 2005 using the Visual Studio IDE.
Debugging SQL Server 2005 Stored Procedures in Visual Studio
Page rendered at Thursday, November 20, 2008 4:33:18 PM (Pacific Standard Time, UTC-08:00)
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.