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 |
|
c0d3wr1t3r
Starting Member
2 Posts |
 Posted - 2009-07-30 : 11:58:54
|
| I have a feeling there is a sql script running when I create a new DB from SQL Server Management Studio.What happens is I create a new DB and 5 tables from another DB on the server are created in the new DB everytime.Im overlooking something just not sure what. Please help!THanks,Joe |
|
|
wshawnmelton
Starting Member
17 Posts |
Posted - 2009-07-30 : 14:48:33
|
| Check the model database. Every database is created from this so if someone added tables into the model database, every time a user creates a database they would be added.w s melton |
 |
|
|
c0d3wr1t3r
Starting Member
2 Posts |
Posted - 2009-07-30 : 15:39:18
|
| That was it! Thank you very much for the answer!Joe |
|
|
|
|
|
|
When creating new DB tables are copied over