Do you use a scheduled job to refresh the test database? If so, then add a step to run your script. If you don't use a scheduled job how do you automate the process of the restore?
Microsoft Certified Master - SQL Server 2008 Follow me on twitter: @keith_tate
Forum Etiquette: How to post data/code on a forum to get the best help[/url]