Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cant find user defined function 1

Status
Not open for further replies.

transparent

Programmer
Sep 15, 2001
333
GB
I have just uploaded my website to my host.

I am experiencing issues with SQL Server user defined functions.

I have a user defined function called fnSplitter.

A stored procedure GetArtistsView uses this.

The default page of website calls this stored proceedure, however it
claims that the function fnSplitter is not available.

If I use query annalsyer to call the function it finds it, however if I call the stored proc through query annalyser, it cannot find it.

The permissions on the function seem fine.

On my local insatllation everything works!!!

Any ideas what the issue might be?
 
When 'objects' are created, they have an owner. When you use a UDF, you need to call it with the owner name.

Ex....

Select * From [red]dbo.[/red]fnSplitter(etc...)

It's possible that the 'owner' of the fnSplitter function is not dbo.

You could try re-creating the UDF, while specifying the owner, liek this...

Create Function [red]dbo.[/red]fnSplitter

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top