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