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

Question

I want to find which stored procedure I've created and also I want to find which stored procedure I've modified in my SQL Server on a particular date like 27 september 2012 (27/09/2012).

Is there any query which will list these procedures that are created and also modified on this date?

Answer 1

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.