finding the last updated procedures or functions in sql server 2000 or sql server 2005

SELECT name FROM sysobjects WHERE type = 'P' AND DATEDIFF(D,refdate, GETDATE()) < 60
----Change 7 to any other day value

--Following script will provide name of all the stored procedure which were created in last 7 days, they may or may not be modified after that.

SELECT name FROM sysobjects WHERE type = 'P' AND DATEDIFF(D,crdate, GETDATE()) < 60


SELECT Specific_Catalog,
Specific_Name, Routine_Type, Routine_Definition,Created,Last_Altered FROM INFORMATION_SCHEMA.ROUTINES
WHERE (Convert(varchar, Last_Altered, 101) like '11/%/2009' or Convert(varchar, Last_Altered, 101)
like '12/%/2009' or Convert(varchar, Last_Altered, 101) like '10/%/2009' or
Convert(varchar, Last_Altered, 101) like '11/%/2009' or Convert(varchar, created, 101)
like '12/%/2009' or Convert(varchar, created, 101) like '10/%/2009')
and Specific_Name like 'spCM_%' and Routine_Type='PROCEDURE'
--Created <> Last_Altered
ORDER BY Last_Altered asc