/ Published in: SQL
This script should be run from the "master" database. It will destroy the dev copy of a database and restore from the live copy.
Code slightly modified from original (linked).
Code slightly modified from original (linked).
URL: http://weblogs.asp.net/mschwarz/archive/2004/08/26/220735.aspx