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
'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 }
SET COMPATIBILITY_LEVEL = { 140 | 130 | 120 | 110 | 100 | 90 }
Thanks for your information
ReplyDeleteThanks for your feedback
Delete