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,


    Thursday, December 12, 2013 10:55 AM


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.

    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,


    Friday, December 13, 2013 7:36 AM