New database contains tables/view/Store Procs 1

[Coppermill]

On my SQL database when ever I create a new database it contains table, views and Stored Procedures from an old database I created sometime ago.

Why and how can I get rid of them?

<<<Bryan>>>

 

[dbomrrsm]

how are you creating the new db ?

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[JamesLean]

Check the model database. Whenever you create a new database in SQL Server it makes a copy of model. Any objects that have been added to model will appear in the new db.

--James

 

[dbomrrsm]

Never knew that James - thanks for the advice.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]