title: Is there a place to find the parameter values used to run a stored procedure?
body: <p>I have just been asked to test 200+ stored procedures (after a DML change and recompile) to make sure that they work in a database that has no unit testing implemented.</p>
  
  <p>As I don't know what "appropriate" input would be for all of these stored procedures, I was wondering if there's a log of procedures that have been run along with the parameters used to run them.</p>
  
  <p>If not, is there a way of testing a bunch of procedures without knowing what valid inputs for their parameters would be?  </p>
  
  <p>Or am I about to learn why systems should incorporate testing from the start of the system?</p>
  
  <p>Thanks</p>