Modified time for query stored procedures in SQL Server

1. Sort all stored procedures by recent changes

SELECT [ name ], [create_date], [modify_date] FROM [sys].[objects] WHERE [type] = ‘P‘ -- 这里也可以替换为：‘U‘,‘IF‘,‘TR‘分别代表用户表，自定义函数，触发器 ORDER BY [modify_date] DESC2. Query the creation and modification time of the specified stored procedure

Select
[Name]
, Create_date
, Modify_date
From
Sys.all_objects
where
Type_desc = N ' sql_stored_procedure '
and name = ' sp_systemstatistics '--Enter name
and Modify_date >= ' 2016-08-05 00:00:00 '

Modified time for query stored procedures in SQL Server