I have the following query and I am calling UDF defined function. But
when i runuit it gives me following error message
Msg 229, Level 14, State 5, Line 1
EXECUTE permission denied on object 'TimeDifference', database
'twcsan', owner 'dbo'.
SELECT
tck.tcktreceived,
tck.ticketid,
tckmsg.tcktmessage,
dbo.TimeDifference(tck.tcktreceived, GETDATE())
FROM tbtickets AS tck
INNER JOIN tbticketsmessages AS tckmsg ON tck.ticketid =
tckmsg.ticketid
Eliyahu Goldin - 21 Jun 2007 09:17 GMT
Why don't you indeed grant execute permission?

Signature
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
>I have the following query and I am calling UDF defined function. But
> when i runuit it gives me following error message
[quoted text clipped - 11 lines]
> INNER JOIN tbticketsmessages AS tckmsg ON tck.ticketid =
> tckmsg.ticketid