Get the list of stored procedures created and / or modified on a particular date?

by

You can try this query in any given SQL Server database:

SELECT 
    name,
    create_date,
    modify_date
FROM sys.procedures
WHERE create_date="20120927"

which lists out the name, the creation and the last modification date – unfortunately, it doesn’t record who created and/or modified the stored procedure in question.

Leave a Comment