mercredi 21 janvier 2015

Is there a place to find the parameters values used to run a stored procedure?

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.


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.


If not, is there a way of testing a bunch of procedures without knowing what valid inputs for their parameters would be?


Or am I about to learn why systems whould incorporate testing from the start of the system?


Thanks


Aucun commentaire:

Enregistrer un commentaire