transparent
Programmer
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?
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?