title: How can I debug a Stored Procedure?
body: <p>I have hundreds of stored procedures in my SQL Server 2012 database.</p>
  
  <p>From my c# code, I am calling one of the stored procedures which in turn calls another stored procedure and so on.</p>
  
  <p>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 .</p>
  
  <p>I cannot alter the stored procedure, is there any way to <code>Watch</code> and <code>StackTrace</code> stored procedures?</p>
  
  <p>Yes, I am using Visual Studio 2010</p>