April 12, 2013 at 2:05 pm
Comments posted to this topic are about the item List of Stored Procedures modified in past 7 days
April 24, 2013 at 7:06 am
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.
April 24, 2013 at 11:14 am
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
April 24, 2013 at 11:23 am
SQL 2000 has a version column. You can use that if you store the previous value, which would require some job that grabs this daily and looks for changes.
April 24, 2013 at 11:43 am
Thanks to both of you, I will investigate further.
October 29, 2015 at 6:57 am
This is really cool, thanks. Works great on my 2008 R2.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply