I have hundreds of stored procedures in my SQL Server 2012 database.
From my c# code, I am calling one of the stored procedures which in turn calls another stored procedure and so on.
There is a failure in stored procedure execution. I need to debug it. For that I need to know what are the values which are sent as parameter when calling stored procedure inside another stored procedure .
I cannot alter the stored procedure, is there any way to Watch and StackTrace stored procedures?
Yes, I am using Visual Studio 2010
For debugging stored procedure, you must be on the PC which has the database engine and then simple you put a break point on it, pass parameter value if it have parameters and then click on debug.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments