Error - is not a recognized function name

• Senthil T

  Hall of Fame

  Points: 3367

  More actions

  February 14, 2006 at 2:52 pm

  #89421

  Hi,

  I created this function, but when I tried to use it in a stored procedure, it says the function is not a recognized function. I created a dummy function to test whats wrong. It throws the same error. This is the dummy test function.

  CREATE FUNCTION [dbo].[fn_test] (@xyz INT)

  RETURNS INT

  AS

  BEGIN

  RETURN @xyz

  END

  This is how I tried to use it SELECT @i = fn_test(10). This is the error message Error 195 'fn_test' is not a recognized function name. Can any one tell me what am I doing wrong.

  Thanks.

• JeffB

  Hall of Fame

  Points: 3541

  More actions

  February 14, 2006 at 2:53 pm

  #620847

  You have to preface the function in the select with dbo.  An example is:

  SELECT @i = dbo.fn_test(10)

   

• Senthil T

  Hall of Fame

  Points: 3367

  More actions

  February 14, 2006 at 3:00 pm

  #620849

  Thanks.