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

How to get the latest modified and crreated tables and columns and procedures in sql server

select name from sysobjects where xtype='u' and (CONVERT(NVARCHAR(10), cast(refdate as datetime), 101) like ('11/%/2009') or CONVERT(NVARCHAR(10), cast(refdate as datetime), 101) like ('12/%/2009'))
select name from sysobjects where xtype='p' and (CONVERT(NVARCHAR(10), cast(refdate as datetime), 101) like ('11/%/2009') or CONVERT(NVARCHAR(10), cast(refdate as datetime), 101) like ('10/%/2009')or CONVERT(NVARCHAR(10), cast(refdate as datetime), 101) like ('12/%/2009')) and name like 'spCM_%'

select CONVERT(NVARCHAR(10), cast(getdate() as datetime), 101)