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

sql, sql-server, sql-server-2005, sql-server-2008

Solution

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.

Problem

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?

Original source

Related problems