• John's solution is nice, because it is using the INFORMATION_SCHEMA views (part of the SQL Standard :), and is portable). But if you prefer SQL Server 2005 (and 2008) system views, you can write the above like:

    SELECT schema_name(schema_id) + '.' + name AS ProcName

    , modify_date

    FROM sys.procedures

    WHERE modify_date > GETDATE() - 7

    Regards,

    Andras


    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software