Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-02 : 08:25:52
|
| Hyva writes "How can I make my own model db and create new db which is copy of my own model db.Why? -> I want to make example data in my own model db which my software users can create new databases (via copying my model db) where all ready exists sample data. (I do not want to use insert script)Hyvaluoja." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-02 : 13:00:48
|
| Instead of using the model database, create your own user database, then insert all of the stuff that you need. Then perform a detach of the database. Now copy the MDF file somewhere so that it is saved. Now attach your database again so that it is available. Then send your MDF file to the users so that they can attach it.Tara |
 |
|
|
|
|
|
New SQL database via copy!