Debug Sql Server Stored Procedures in visual studio

These are the following steps required to debug stored procedure in visual studio

1. Go to Server Explorer (Visual Studio --> View menu --> Server Explorer),


2. Right click on Data Connections --> select Add Connection,


3. Here type sql server name and select authentication type(windows or sqlserver), and then type your database. Click ok. Now you are connected to sql server.


4. Select a SPROC and Right click on stored procedure --> select Step Into Stored Procedure.


5. Select a SPROC and Right click on stored procedure --> Execute--> Give the default values to debug. Now it starts Debugging.