Though I have heard of it I never wanted to try it till yesterday, the debugging a SP in Visual Studio .NET is a straight forward job as follows - Open your project - Add a New Connection to Visual Studio Select and open the respective SP and break point can be added then right click on the Stored Procedure in the Server Explorer, select Step into Stored Procedure "One more setting" – go to the project settings, Set Debuggers SQL Server true "Happy Debugging"
Universe is within you