Wednesday, 16 January 2013

SQL 2012 - Compatibility Level 110

In SQL Server 2012, the default compatibility level is 110
For a database to include 2012 functionality it needs to be on a SQL 2012 Server in a 2012 Compatibility Level of 110.

ALTER DATABASE MigratedDb
SET COMPATIBILITY_LEVEL = 110;
GO

Compatibility Levels
  • 70 - SQL Server 7
  • 80 - SQL Server 2000
  • 90 - SQL Server 2005
  • 100 - SQL Server 2008 / 2008 R2
  • 110 - SQL Server 2012


MsDN Compatibility Modes

No comments: