none
Execution error: 'the function name is not a recognized built-in function name'

    Question

  • Hi,all here,

    Would please any experts here give me any guidance for this execution error? (as below)

    'The "function name" is not a recognized built-in function name'.

    The function is already available in the sample database, but it is not recognized yet? Dose it mean that the function is written in CLR language which requiring me to register the assembly to the server instance first of all?

    Thanks a lot for any guidance and advices for that.

    With best regards,

    Yours sincerely,

     

    Thursday, September 14, 2006 11:29 AM

Answers

  • SQL Server scalar user defined functions must be called using 2 part names. You will see this error if you attempt to call the functions using a 1 part name. Can you check if that is the problem ?

    So if your function name is "function1" and is defined in the dbo schema, then instead of

    "select function1()" you should call it as "select dbo.function1()"

    Let me know if that helps.

     

     

    Friday, September 15, 2006 3:19 PM

All replies

  • How did you try to execute /call the function ?

    Thursday, September 14, 2006 2:16 PM
    Moderator
  • Hi, Jens,

    I called the function within a T-SQL query in the query editor in SSMS.

    Thanks.

    With best regards,

    Yours sincerely,

    Friday, September 15, 2006 9:04 AM
  • SQL Server scalar user defined functions must be called using 2 part names. You will see this error if you attempt to call the functions using a 1 part name. Can you check if that is the problem ?

    So if your function name is "function1" and is defined in the dbo schema, then instead of

    "select function1()" you should call it as "select dbo.function1()"

    Let me know if that helps.

     

     

    Friday, September 15, 2006 3:19 PM
  • Hi, Asvin,

    Thank you very much for your very helpful guidance.

    Before I did not use two part names since I thought the function is defined within the schema where I created the new query, so the system probably automatically identify the user-defined function within it as other operations. But it got the problem when calling the user-defined function.

    Yes, it now sorted out-exactly as the problem you mentioned.

    Thank you very much.

    With best regards,

    Yours sincerely,

     

    Friday, September 15, 2006 4:00 PM
  • thats awful. What if I have to call 1 function from another. I have multiple customers with different schema names. Now I have to write cripts for each customer separatly??? thank U very much!

    Thankfully most customers have oracle db.

    Thursday, April 03, 2008 7:37 AM
  • Brilliant! _ I would never have guessed that it was something as simple as that.
    Thursday, September 17, 2009 12:41 PM
  • Asvin Ananthanarayan 

    you saved me hours!! Thanks!

    wokao
    Monday, October 26, 2009 1:03 AM
  • restart

    Monday, February 07, 2011 3:36 PM
  • Mr. Asvin Ananthanarayan,

    It seems very much simple from your help.

    Thanking you,

    Md. Sumonur Rahman [Sumon]

    Software Engineer,

    Mediasoft Data Systems Ltd,

    Dhaka, Bangladesh.


    Wednesday, December 21, 2011 4:28 AM
  • Thank you so much this helped :) cheersss
    Friday, February 10, 2012 12:30 PM
  • Thank you this helped me Cheerssss
    Friday, February 10, 2012 12:32 PM
  • Thanks! Gr8 help :)
    Monday, March 19, 2012 5:59 AM
  • Thanks.. It worked...

    I have written with example on below url.

    http://www.xpode.com/ShowArticle.aspx?ArticleId=585

    Regards,
    Rohit



    • Proposed as answer by rohit kakria Wednesday, April 18, 2012 12:06 PM
    • Edited by rohit kakria Wednesday, April 18, 2012 12:07 PM Example link missed.. So edited
    Wednesday, April 18, 2012 12:03 PM
  • OK, so what happens when that DOESNT work...???

    I wrote a very simple Scalar function, saved it, refreshed everything - I can see the function now - and yet when I call it with "dbo.fn_FunctionName" SQL Server 2008 R2 still gives me the "invalid object"...  I even tried tacking in the Database name so that "Database.dbo.fn_FunctionName" might do the trick - NOPE!  As usual the most simple things (like trying to get any work done) are what Microsoft seems to have unique expertise at making either impossible or like pulling an elephant out of your...  (well, where the Sun dont shine!)

    Now before you start asking me the 2,000 questions - did I refresh this, that and the other thing, the answer to all is yes, yes,yes, yes, yes, etc. etc. - that is I have done everything I would have ever had to do in the past to see and use this function - IF I stopped getting this pain in the butt "invalid object" error.

    My only solution seems to be to constantly go to my older machine, do things in SQL 2005, and then move them over to my Win 7 / SQL 2008 R2 machine.

    Thursday, June 14, 2012 4:40 PM
  • Try Ctrl+Shift+R to refresh the intellisense. Just doing the right-click refresh is not enough. Hope this helps
    Thursday, July 26, 2012 1:25 PM
  • Hi Asvin

    I used the function substr(patelectionperiods.hipps,1,4) for one of my query..

    when I run that query its give me all the time Error that ;

    'substr' is not a recognized built-in function name. (Microsoft SQL Server Native Client 11.0)

    I used your formula the select dbo.function() but still it gives me the same error.

    So can you please help me in this error.

    Thanks with Best regards

    Your's Sincerely

    CP Patel


    CP Patel

    Tuesday, May 21, 2013 1:35 PM
  • This thread is 7 years old.  Posting a "me to" reply to one this old (and marked as answered) is not an effective way to resolve problems.  In addition, you can use the online documentation that comes with sql server to look up any functions that are provided by tsql.  If you do, you will notice that substr is not one of them. 

    I suggest you start a new thread for your question.  If you do, you will need to post more information than a fragment of your actual query and the error message. Please have a look at the sticky posts at the top of the forum - these include information about how to post questions effectively, including providing important and useful information that will be asked of you if it is missing.

    Tuesday, May 21, 2013 2:45 PM