locked
compatibility level server (110) vs compatibility level database (100) RRS feed

  • Question

  • Hi folks,

    can anyone tell me why the compatibility level of the Windows Azure SQL Database SERVER is 110 but the compatibility level of a DATABASE is 100?

    Greetings from Germany,

    Tobias

    Thursday, December 12, 2013 10:55 AM

Answers

All replies

  • Hi Tobias,

    According to your description, you need to note that there is  difference between database version and database compatibility level. I guess you check the database version via select statement, and get the version number-11.0.***, then you think the  compatibility level of SQL Server is 110. You confuse the distinction between database compatibility level and database version. For more information, see: What's the difference between database version and database compatibility level?

    There is a similar issue, you can review the following post.
    http://stackoverflow.com/questions/10677993/sql-azure-compatibility-level

    Thanks,
    Sofiya Li

    If you have any feedback on our support, please click here.


    Sofiya Li
    TechNet Community Support

    • Marked as answer by Tobias Jamin Friday, December 13, 2013 8:04 AM
    Friday, December 13, 2013 5:22 AM
  • Hi Sofiya Li,

    you are absolutely right. A colleague of mine has build a wrapper around SQL Management Objects with the following code

    public int ServerCompatibilityLevel
    {
    	get { return _server.VersionMajor * 10; }
    }
    

    So I walked right into the trap! Argh!

    Thanks again and have a nice weekend,

    Tobias

    Friday, December 13, 2013 7:36 AM