Follow steps below to debug SPROCS.
- Go to Server Explorer (Visual Studio -- View menu -- Server Explorer),
- Right click on Data Connections -- select Add Connection,
- 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.
- Select a SPROC and Right click on stored procedure -- select Step Into Stored Procedure.
- Give the default values to debug. Now it starts Debugging.
Let me know your feedback on it,
No comments:
Post a Comment