The subset of sys.objects with the object types = P, X, RF, and PC can be found in the object catalog view sys.procedures.
P = SQL Stored Procedure
X = Extended stored procedure
RF = Replication-filter-procedure
PC = Assembly (CLR) stored-procedure
In other words, the columns of this view (sys.procedures) inherit from sys.objects.
By executing the following statement you can obtain a list of all user-defined stored procedures along with their creation and modification dates and times.
Statement:
SELECT
name,
type_desc,
create_date,
modify_date
FROM
sys.procedures
Big Data and SQL 