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,

 

Answer 1

How did you try to execute /call the function ?

Answer 2

Hi, Jens,

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

Thanks.

With best regards,

Yours sincerely,

Answer 3

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.

 

 

Answer 4

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,

 

Answer 5

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.

Answer 6

Brilliant! _ I would never have guessed that it was something as simple as that.

Answer 7

Asvin Ananthanarayan 

you saved me hours!! Thanks!

---

wokao

Answer 8

restart

Answer 9

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.

Answer 10

Thank you so much this helped :) cheersss

Answer 11

Thank you this helped me Cheerssss

Answer 12

Thanks! Gr8 help :)

Answer 13

Thanks.. It worked...

I have written with example on below url.

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

Regards,
Rohit

Answer 14

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.

Answer 15

Try Ctrl+Shift+R to refresh the intellisense. Just doing the right-click refresh is not enough. Hope this helps

Answer 16

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

Answer 17

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.

Answer 18

This is the answer I wish I had years ago.  Thank you for saying it specifically.  the dbo. is exactly what is needed.