Change SQL Server Compatility Level to 110
Issue #1236
resolved
This makes the function TRY_CONVERT available for use; which will help to get more robust uploads from Excel.
Comments (2)
-
reporter -
reporter - changed status to resolved
Changes applied on live servers
- Log in to comment
All databases on KEMIS, FEDEMIS and MIEMIS servers with Compatibility_Level 100 have been upgraded to 110.
Development machines should be changed in the same way.
Run this script to generate script to upgrde any eligible database:
Run each of the generated ALTER DATABASE statements ( names are based on current server):
Then, in each Pacific EMIS database that has been upgraded run this script to complete the upgrade: THIS IS CRITICAL!
Now this statement:
should show all databases have compatibility level at least 110. Note that the Compatibility Level of non-Pacific EMIS databases will depend on the version of SQL server in which it is created.
You can see the compatibility level in SSMS: before these changes you’ll see:
After update: