Thank this author by sharing:
By Sourav Mukherjee, 2011/04/08
Copy and Paste the script to the SSMS query window. Navigate to the database and execute.
You can use the script in the job step also which you can use to refresh the database for repeated refresh of database requests.
Database
Database Synchronization
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
