Last post Sep 01, 2017 02:45 AM by Deepak Panchal
Aug 31, 2017 09:44 AM|tapan2017|LINK
i am using visual studio 2013 and often set break point on code when call store procedure. when we are passing data to store proc that we can debug from IDE but some time we need to debug store proc from VS IDE 2013. so please tell me way out to debug store
proc from VS2013 IDE when we pass data from my program to store proc.
need step by step details. thanks
Sep 01, 2017 02:45 AM|Deepak Panchal|LINK
you can try to follow the steps below.
Open Server Explorer.
NOTE: It is not necessary to add a Data Connection to work with a SQL Server server because SQL Server servers are listed under the Servers node also. You will use the Servers node in the steps that follow; however, you can use
a Data Connection to you SQL Server server in the same way.
How to debug stored procedures in Visual Studio .NET
other useful links:
Debug SQL Server 2012 Stored Procedure in Visual Studio 2013, Step by Step
Debug Stored Procedures in Visual Studio and SSMS