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