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

Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You

Popular Posts

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

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

Cannot convert "Column" between a unicode and a non-unicode string data types in SSIS