Copying an MSSQL 2000 database

[Howie Hamlin]

I have an application where each user gets a copy of a database.  Right now, we're creating the database and tables in a fairly lengthy template and, every time we add a table or column, we have to modify the template.  What I'd really like to do is have a standard database with all the tables, indexes, etc. but no data and then use that database as a template for creating a new user database.

Is there an easy way to do this?

Thanks,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
PrismAV - Virus scanning for ColdFusion applications
>>> Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---