rob-660781 (4/24/2013)
Is there a way to modify this to work in SQL 2000? I can get a list of stored procedures by changing sys.objects to sysobjects and removing the modify_date portion of the code. Is there another table in SQL 2000 that has the modify date? Thanks.
I don't believe this is possible as modify_date is not part of sysobjects system table in SQL 2000. It is explained at the linked page under the section entitled "Is it Possible to See the Create/Modify Date in SQL Server 2000?": http://jwcooney.com/2012/03/08/sql-server-search-stored-procedure-createmodify-date-or-text-using-tsql/. The author provides an approach on how you could solve the lack of a modify_date column.
<<EDIT:>>
Try this query, maybe it works for you:
SELECT
SPECIFIC_NAME,
CREATED,
LAST_ALTERED
FROM
Information_Schema.Routines
Found it at http://dbaspot.com/sqlserver-programming/418380-how-get-store-procedure-sql2000-last-modify-datetime-thanks-print.html but it would appear that CREATED and LAST_ALTERED are the same. So in the end that isn't really effective either.
<</EndEdit>>
Regards,
/bitBIG