• Hi Jeff

    I looked up the def for routines view in SQL 2005 and here' what i found ,

    o.create_date AS CREATED,

    o.modify_date AS LAST_ALTERED

    FROM

    sys.objects$ o LEFT JOIN sys.parameters c

    ON (c.object_id = o.object_id AND c.parameter_id = 0)

    I tried it out an it worked fine. Could you provide an example where this would fail ?

    Jayanth Kurup[/url]