SQL Server 2012 Compatibility Level

SQL 2012 Compatibility Level

With SQL Server 2012, there was a new compatibility level being introduced, level 110 the new SQL 2012 compatibility level.

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 = SQL Server 7.0
• 80 = SQL Server 2000
• 90 = SQL Server 2005
• 100 = SQL Server 2008 and SQL Server 2008 R2
• 110 = SQL Server 2012

Changing the compatibility level in SQL Server may change the behavior of specific of the functionality of the SQL Server. Be sure to research and test before changing compatibility levels.

Sp_dbcmptlevel dbname
GO
Sp_dbcmptlevel dbname, 110
GO
Sp_dbcmptlevel dbname
GO

This TSQL will generate the following output:

The current compatibility level is 100.
The current compatibility level is 110.

Once you change the compatibility level, you will want to be sure that your system still runs correctly.

Related Links

• Stedman Solutions, LLC – SQL Server consulting
• Database Health Monitor
• SQL Server 2014 Compatibility Level
• SQL Server 2008R2 Compatibility Level
• SQL Server 2008 Compatibility Level
• SQL Server 2005 Comaptibility Level

More from Stedman Solutions:

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!