Check for Stored Procedure Created and Last Modified Date

This blog will tell you how to find the created date and last modified date of a stored procedure.

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'