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:
Post a Comment