Thanks for your replies.

The purpose of my testing is that i will deploy other peoples stored procedures into production enviroment and i would like to have a testing procedure...