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

Announcing backup and restore improvements for large datasets near the size limit

Enhanced refresh with the Power BI REST API is now generally available

What’s New in SQL Server 2014 since SQL Server 2008 R2