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
 

 

or,

In Windows

 

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

 

Now perform your event through Asp page/Win Forms .You will see your debugger passes through
 

your .net code with stored procedure.