Hello,
Problem
After upgrading a SQL Server database should you leave the compatibility level at the lowest level?
Solution
No, after upgrading a SQL Server database you should upgrade the database compatibility level.
Reference:
https://bousteadgis.sharepoint.com/teams/au-ps/SupportCenter/Knowledge%20Library/Administering%20SQL...
"A Note About Compatibility Level"
For example, if upgrading the database to SQL Server 2014 change the following setting on each database:
SQL Server Management Studio > Databases > Right-click your database > Properties > Options > Compatibility Level -> SQL Server 2014 (120)
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-leve...
Mark
