error 208 invalid object for UDF call :/ 2005

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

August 28th, 2015 12:56pm

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?

Free Windows Admin Tool Kit Click here and download it now
August 28th, 2015 1:02pm

awesome! many thanks - how silly of me to miss that off :/ :D

cheers

dan

August 28th, 2015 1:23pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics