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

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.

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