locked
error 208 invalid object for UDF call :/ 2005 RRS feed

  • Question

  • hi guys,

    im stuck on this one - ive check lots of posts on net about it but cant figure it out :(

    im using server 2005 express - making the below call - it was working but now get error - ive restarted SSMS a few times, and made sure ive got the northwind db selected in dropdown etc

    select * from dbo.moretotalorders('alfki')

    I can clearly see the scalar function listed in object viewer

    help!

    thanks

    dan


    danx55

    Friday, August 28, 2015 4:54 PM

Answers

  • Since it's a scalar function, it can not be executed that way. It has to be

    select dbo.MoreTotalOrders('alfki') as [Total]

    Can you post definition of that function?


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog


    My TechNet articles

    • Marked as answer by danx551 Friday, August 28, 2015 5:20 PM
    Friday, August 28, 2015 5:00 PM

All replies

  • Since it's a scalar function, it can not be executed that way. It has to be

    select dbo.MoreTotalOrders('alfki') as [Total]

    Can you post definition of that function?


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog


    My TechNet articles

    • Marked as answer by danx551 Friday, August 28, 2015 5:20 PM
    Friday, August 28, 2015 5:00 PM
  • awesome! many thanks - how silly of me to miss that off :/ :D

    cheers

    dan


    danx55

    Friday, August 28, 2015 5:21 PM