Post reply

The 2005 Default Compatibility Level

  • March 19, 2008 at 9:43 pm

    #128318

    Comments posted to this topic are about the item The 2005 Default Compatibility Level

  • March 20, 2008 at 9:22 am

    #792072

    I sort of guessed the "correct" answer.

    I have a couple of comments: server does not have a compatibility level. This is a Database property, not a server property.

    The default will depend on what exactly you are going to do. If you create the new database, then the answer is correct. If you attach or restore the database from another server, then the compatibility level will be whatever it was before on another server.

    Regards,Yelena Varsha

  • March 20, 2008 at 10:20 am

    #792105

    So what's the value of SQL 2008 cmptlevel? 10, 100? I don't have CTP installed anymore sorry...

  • March 20, 2008 at 10:35 am

    #792113

    mojo (3/20/2008)

    So what's the value of SQL 2008 cmptlevel? 10, 100?

    For SQL Server 2008 the value is 100

    BOL:

    http://msdn2.microsoft.com/en-us/library/bb933794(SQL.100).aspx

  • March 20, 2008 at 1:05 pm

    #792202

    If you create the new database, then the answer is correct.

    Not exactly true. It will be set 90 unless the model database has a lower compatibility level. (From BOL). So technically, you can set all new databases to be 80, etc.

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

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

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