27 August 2022

List of Stored Procedures with Create and Last Modify Date

Use this code to list all your Stored Procedures in your Database with Create and Last Modify Date. 


select db_name() as db_name,

SCHEMA_NAME([schema_id]) as schema_name,

name as sp_name,

create_date, 

modify_date as last_modify_date

from sys.objects

where type = 'P'

ORDER BY last_modify_date




No comments:

Post a Comment