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
- 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"
Comments