Upgrade Notes

×

Due to constantly evolving technology, the database compatibility level will need to be adjusted to 110 (SQL Server 2012) or greater. You can do this manually or by running a query.

Manual

This presumes your SQL Server has also been upgraded; if it has not, you'll need to simply run the query below.

  • In SQL Server Management Studio, right-click on the database and select Properties
  • Click on the Options tab
  • In the Compatiblity level dropdown, change to SQL Server 2012 (110) (or greater if that's available)

Query

  • Alter Database (YOUR DB) set compatibility_level = 110