Skip Navigation Links
Home
Articles
SQL Server 2012
SQL Server 2014
SQL Server 2016
FAQ
Forums
Practice Test
Bookstore
Tip of the Day : How to Get a List of User Views Within a Database
Error Messages
Home > SQL Server Error Messages > Msg 195 - Function Name is not a recognized function name.
SQL Server Error Messages - Msg 195 - Function Name is not a recognized function name.

Error Message

Server: Msg 195, Level 15, State 10, Line 1
Function Name is not a recognized function name.

Causes:

This error is encountered when invoking a scalar-valued user-defined function using just the single-part name of the function and not including the owner.

To illustrate, let’s say you have the following scalar-valued user-defined function:

CREATE FUNCTION [dbo].[ufn_Greatest]
( @pInt1 INT, @pInt2 INT )
RETURNS INT
AS
BEGIN
    IF @pInt1 > @pInt2
        RETURN @pInt1

    RETURN @pInt2
END
GO

Invoking this scalar-valued user-defined function using just the single-part name of ufn_Greatest will generate the error:

SELECT ufn_Greatest ( [FirstTestScore], [SecondTestScore] ) AS [HigherScore]
FROM [dbo].[StudentScores]
Server: Msg 195, Level 15, State 10, Line 1
'ufn_Greatest' is not a recognized function name.

Solution / Work Around:

When invoking scalar-valued user-defined functions, always use the two-part name of the function, which is basically calling the function with the owner name as can be seen from the following example:

SELECT [dbo].[ufn_Greatest] ( [FirstTestScore], [SecondTestScore] ) AS [HigherScore]
FROM [dbo].[StudentScores]
Related Articles :