SQL Server 2008 R2 Compatibility Levels
There was no change to the compatibility levels between SQL Server 2008 and SQL Server 2008 R2. SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 = SQL Server 6.5 70 …