Post reply

about system database?

  • January 25, 2013 at 8:53 pm

    #269735

    hi

    can we create database with out using model database or change my model database with other database

    thanks

    with best regards

    pradeep

  • January 26, 2013 at 3:01 am

    #1581260

    Creating any database uses model as the template.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 26, 2013 at 5:21 am

    #1581274

    hi

    i want create database by using my own model database not system model database

    thanks

    best regards

    pradeep

  • January 26, 2013 at 7:12 am

    #1581285

    Can't be done, the system database model is used as a model for new databases.

    You can put small objects in model (small, not huge, model is the template for TempDB too), or you can use deployment scripts to create a standard user database.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 26, 2013 at 9:16 am

    #1581300

    mpradeep23 (1/25/2013)

    can we create database with out using model database or change my model database with other database

    any reuirement ? or just a curiosity or interview question ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Viewing 5 posts - 1 through 4 (of 4 total)

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