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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Database Creation

Author  Topic 

duplo1
Starting Member

2 Posts

Posted - 2009-08-19 : 11:17:55
Hi there,

We are using SQL 2008 Enterprise x64 and have the following problem. Every time we create a new database it automatically populates the tables from the last database that was created. How can we stop that resp. what are we doing wrong ???

Please help !

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-08-19 : 11:28:10
Check What's inside your Model Database? It gets copied from there.
Go to Top of Page

duplo1
Starting Member

2 Posts

Posted - 2009-08-19 : 11:35:54
You are right. Just saw that. I don't know why it did that. Anyway, is there a possibility to recreate the Model Database from scratch ???
Go to Top of Page
   

- Advertisement -