Post reply

New Database Creation Prepopulates with Objects from Existing Database

  • May 7, 2008 at 10:12 am

    #187434

    I've never seen this problem before, and I wasn't able to find similar posts on the forums, so here goes:

    I go to create a new database without changing any default options and values, and when I check the tables, views, and sps, they've been pre-populated with objects from another database.

    Any ideas as to why this happened and how this can be fixed?

    Thanks in advance.

  • May 7, 2008 at 10:32 am

    #811936

    Are those objects in your Model database? That's what gets used as the template for new databases, so any objects in Model at the time you create a new database would get created in your new database.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • May 7, 2008 at 10:43 am

    #811944

    Thanks so much, yes, that was it.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply