Tag: Get Last Modified Function Date

To get the last modified function​​ date, execute the script below.

SELECT​​ name,

 type_desc

 create_date,

 modify_date

FROM​​ sys.objects​​ 

WHERE​​ RIGHT(type_desc,​​ 8)​​ =​​ 'FUNCTION'

ORDER​​ BY​​ modify_date​​ DESC