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

Enable 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.