try_convert is not a recognized built-in function name

Error :
'try_convert' is not a recognized built-in function name
              OR
How to change Compatibility Level
 
1. For checking Compatibility Level

USE DB_Name;
GO
SELECT compatibility_level
FROM sys.databases WHERE name = 'DB_Name';
 
2. Update Compatibility Level

ALTER DATABASE DB_Name  
SET COMPATIBILITY_LEVEL = { 140 | 130 | 120 | 110 | 100 | 90 }


Comments

Post a Comment

Popular posts from this blog

Failed to execute the package or element. Build errors were encountered

Restore of database 'DataBase_Name' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

On-premises data gateway December release