Cannot find either column dbo or the user-defined function or aggregate dbo.fnMinValue or the name is ambiguous

Question

Hi!

I've created a UDF to find the min of two integer values as

CREATE FUNCTION dbo.fnMinValue
               (@ColumnA MONEY,
                @ColumnB MONEY)
RETURNS MONEY
AS
BEGIN
    RETURN (0.5 * ((@ColumnA + @ColumnB) - abs(@ColumnA - @ColumnB)))
END

and I'm calling this UDF in folloeing format

SELECT cast(dbo.fnMinValue ( @lcount,@Rcount) as int)

when i execute this in server it gives the following error

Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fnMinValue", or the name is ambiguous.

Plz help me out..

sham suman · Answer

Hi May be this error is coming because what the fuction you have created is not available in your database. Check your dbo.fnMinValue function in below path of your database. Go to database- Programmability - Function-Scalar-valued Function. If the dbo.fnMinValue function is available you will not get this error.