Finding when a stored procedure was last created or modified


Please use below code to find when a stored procedure was last created or modified.



SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND name = '[Name of the stored procedure]'
GO

Please Note: This code is tested on SQL 2005/2008/2008 R2

Comments