[Solved] SQL SERVER Error : Invalid object name 'string_split'.

Tutorialsrack 04/11/2023 SQL SQL Server

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:

1. Permission Issues: If you don't have the necessary permissions to execute the STRING_SPLIT function, you may encounter this error. Make sure your user has at least EXECUTE permission on the function.
2. Compatibility Level: The STRING_SPLIT function 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:

Read Here: How to Check a Database’s Compatibility Level in SQL Server

Read Here: How to Change the Compatibility Level of a Database in SQL Server

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!

Related Posts