Check for Stored Procedure Created and Last Modified Date

Run this query to get the details of a specific stored procedure or comment on the where clause to see the details of all the stored procedures.

 

select
SPECIFIC_NAME AS StoredProcedureName,
SPECIFIC_CATALOG AS DatabaseName,
CREATED AS CreateDate,
LAST_ALTERED as LastModifiedDate
from
information_schema.routines
where routine_name = 'Stored Procedure Name'