Debug SQL Server Stored Procedure with visual studio application

TO EXECUTE STORED PROCEDURE WITH .NET APPLICATION
  1. Open Asp.net / Windows Application in Visual Studio. Create new Project.
NOW, Go to the Properties of the Application.
 
 In Asp.net
 
ASP.png
 
or,

In Windows

 
Windows.JPG

E
nable Sql Server Debugging. . .Now!!! 
  1. Go to View --> 
  2. Server Explorer --> 
  3. Right Click on Data Connection -->
  4.  Add Connection -->
     
  1. Choose Server Name --> 
  2. User Id --> 
  3. Password -->
  4.  Then Choose Your Database -->
  5.  Click OK -->
  6. Now right click on database and Enable Application debugging.

     
  7. After that Right click on stored procedure -->
  8. Step Into Stored procedure --> 
  9. Fill your Input Parameters(if there is any input param) 
  10. Click OK. Now set debugger in stored procedure. (Like below image). 
Debug.JPG

 
Now perform your event through Asp page/Win Forms .You will see your debugger passes through
 
your .net code with stored procedure.
Next Recommended Reading Shortcuts For Debugging In Visual Studio