List out last modified procedures and functions in sql server

To List out last modified procedures and functions in sql server

Use below query

 

SELECT name, create_date, modify_date,type

FROM sys.objects

WHERE type IN ('FN','V','P','U','TF')

AND DATEDIFF(D,modify_date, GETDATE()) < 6

ORDER BY modify_date

 

 

Here are different types used in IN clause in WHERE condition:

 

    FN - Scalar valued function

    V - View

    P - Stored Procedure

    U - Table

    TF - Table valued function