I have a weird one for you that I was hoping to get some help with.
I created and deleted a few functions.
Then I created a new one (Called RAT)
When I call it with SELECT dbo.rat(@param,@param) it comes back with a
"Cannot find either column "dbo" or the user-defined function or aggregate "dbo.RCHARINDEX", or the name is ambiguous."
Now, there used to be a function called RCHARINDEX, but its gone, and it doesnt come up in the list of functions.....
I deleted it because for some reason I couldnt call it, but another function in the list worked fine, so its possibly a compounded problem,
When I run
select 1 from dbo.sysobjects where id = object_id('[dbo].[RAT]')
select 1 from dbo.sysobjects where id = object_id('[dbo].[RCHARINDEX]')
I get a hit on the first one, but not on the second one.
I did drop the functions using the command:
IF EXISTS (select 1 from dbo.sysobjects where id = object_id('[dbo].[RAT]') )
DROP FUNCTION [dbo].[RAT]