In this article, you’ll learn how to solve an SQL Server error: invalid object name 'string_split'. The error message "
Invalid object name 'string_split'" typically occurs when you are trying to use the
STRING_SPLIT function in SQL Server, but the function is not recognized. This issue may occur for one of the following reasons:
STRING_SPLITfunction, you may encounter this error. Make sure your user has at least
EXECUTEpermission on the function.
STRING_SPLITfunction is available in SQL Server 2016 and later versions. If you are using an earlier version of SQL Server, you will encounter this error because the function is not supported. You can either upgrade your SQL Server instance or use an alternative method to split strings, as mentioned in previous responses.
This function was introduced in SQL Server 2016, To use this function, you need to check the compatibility level of your database, if it is below 130, then you need to upgrade your database compatibility level to at least 130.
Here are the ways to check and Alter the Compatibility level of your Database:
I hope this article will help you to understand how to solve SQL Server error: invalid object name 'string_split'.
Share your valuable feedback, please post your comment at the bottom of this article. Thank you!