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 |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2002-06-21 : 14:24:45
|
| I know that if I add add fields, tables, etc to the model database,I can set a standard structure. My question is if I want:field afield bto always show up in new tables created. Where do I add these fields, what table in the model? |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-06-21 : 15:07:02
|
quote:
Where do I add these fields, what table in the model?
The model database doesn't work in that fashion. When a new database is created, the model database is effectively backed up and restored to create the new database. It does not provide a template for tables created after the fact, only what the database will look like at the time of creation.Jonathan Boott, MCDBA |
 |
|
|
|
|
|
ModelDb question