Hi i'm using a stored procedure ..
Which contain the function dbo.split(....)
When i try to use this stored procedure in the local it works fine.
when i try to use that stored procedure i get the error invalid object dbo.split
can some one please help
Thank you

I assume you are using one of the split() function sql scripts that is readily available on the net and that it returns a TABLE data type as opposed to a varchar or int.

You can only call a function like this:
SELECT split('My String', ' ')

when the function returns a scalar value (just one value such as a varchar or int value) but when the function returns a result set such as a TABLE you have to do something like this:

SELECT * from split('My String', ' ')

This will return you all of your results.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========