Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

  • Jeff Moden - Thursday, November 30, 2017 10:46 AM

    Perry Whittle - Thursday, November 30, 2017 10:29 AM

    Jeff Moden - Wednesday, November 29, 2017 9:26 AM

    Perry Whittle - Wednesday, November 29, 2017 9:03 AM

    master starts first, id is 1
    tempdb is usually just before model, especially evident like Gail said if tempdb is not present as it copies tempdb from model, something which it cannot do if the files are already open.
    MSDB is last

    Interesting... how is model used when creating a new database then?

    Ever tried viewing model or its properties while a database is being created.

    No.  What happens?

    usually an error failing to lock the database

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing post 91 (of 90 total)

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