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
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.