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 |
|
Keshaba
Yak Posting Veteran
52 Posts |
 Posted - 2008-01-24 : 02:14:30
|
| Hi I am using sql server 2005 express .Whenever I try to create new Database all tables and views I had created in a database name FleetDB comes in.I am having problem in creating Fresh database.How can i solve this problem.Please HelpKeshab |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-24 : 04:36:48
|
| check your model database. the model database is used as a template for when you create new databases. any objects in the model database will also be created in any new database created.If you have objects in model you can remove them. just be careful that someone isn't using this database by mistake before dropping tables and/or other unnecessary objects there.-ec |
 |
|
|
Keshaba
Yak Posting Veteran
52 Posts |
Posted - 2008-01-24 : 05:24:12
|
| I had removed all unnecessary tables from model database and now itzokie I don't have any problem in creating new database.Thanks..Keshab |
|
|
|
|
|
|
problem in New database creation