I have a SQLServer database that consists about 100 tables, 10 views and numerious stored procedures. In addition, I have a number of independent test programs running against on this database. What I need is to automate these test programs so that they can be run nightly. I can write a master test program that sequentially calls each of the test programs (modules). The question is, how do I refresh the SQL database (at runtime) at the beginning of each test program (module)?

Thanks in advance.