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 – Embed your Power BI organizational apps in Microsoft Teams Channels and Meetings

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

Dataset refresh cancellation is now available in Power BI Premium