User defined function

From: Nandita Reshamwala (Nandita.Reshamwala_at_geac.com)
Date: 05/20/04

  • Next message: bob: "NOT IN More Efficient???" 
    Date: Thu, 20 May 2004 16:00:33 -0700

    I have created user defined function
    DateIsEnded . Owner of the function is 'pthdbo'
    (connected User of login )

    In query analyser I am trying to use this function but
    it gives me error - invalid object name DateIsEnded - if I
    specify it without owner pthdbo.

    select rfofficer_code, DateisEnded(rfoff_end_date) as ended
    from rfoff
    order by ended;

    Owner of rfoff table is also pthdbo.But it doesn't
    complain about rfoff. If I specify owner name with
    function it works.

    select rfofficer_code, pthdbo.DateisEnded(rfoff_end_date)
    as ended
    from rfoff
    order by ended;

    My question is
    why it is required to specify owner name before user
    defined function though connected user is the owner of
    the user defined function?

  • Next message: bob: "NOT IN More Efficient???"

    Relevant Pages

    • Re: User Defined Functions
      ... then why not for a UDF." ... Coming to the table issue, when you say ....FROM rfoff, the lookup ... when they are owned by a common owner like dbo. ... > why it is required to specify owner name before user ...
      (microsoft.public.sqlserver.setup)
    • Re: User Defined Functions
      ... > (connected User of login) ... > specify it without owner pthdbo. ... > Owner of rfoff table is also pthdbo.But it doesn't ... > why it is required to specify owner name before user ...
      (microsoft.public.sqlserver.setup)
    • User Defined Functions
      ... Owner of the function is 'pthdbo' ... (connected User of login) ... Owner of rfoff table is also pthdbo.But it doesn't ...
      (microsoft.public.sqlserver.setup)