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