All geek questions in one place

What is SQL Server 2008 r2 compatibility level?

What is the compatibility level of SQL Server 2008 r2?

Does anyone know when it will be released?

+3
source share
3 answers

Although the compatibility in SQL Server 2008 R2 remains the same, care should be taken because the internal version of the database is located in R2. What does this mean for you? If you are attaching a database on R2, you cannot roll back or revert to SQL Server 2008.

http://sqlskills.com/BLOGS/PAUL/post/SQL-Server-2008-R2-bumps-the-database-version.aspx

If you do not know the difference between the compatibility version and the database, you need to catch the next entry from Paul Randal.

http://sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-13-Difference-between-database-version-and-database-compatibility-level.aspx

+6

, 10 - ( Sql Azure). , 2010 .

+1

The compatibility level is still 10.

There are no changes in the T-SQL / DB-Engine.

+1
source

Source: https://habr.com/ru/post/1726552/

More articles:


All Articles