June 14, 2005 at 5:05 am
I need to determine which functions and/or sprocs were altered since a given date. I looked at the system view INFORMATION_SCHEMA.routines but the LAST_ALTERED is always the same CREATED. Is there anyway to do this using the system views or procedures?
Thanks,
DougS
June 14, 2005 at 6:05 am
No, unfortunately this is not stored in SQL Server. The LAST_ALTERED and CREATED columns in the view both show the column crdate in sysobjects, so that is why they are the same.
June 14, 2005 at 6:24 am
Is this behavior changed in Yukon?
June 14, 2005 at 7:22 am
Yes, it is actually. The catalog view sys.objects now has two columns, create_data and modify_date, which the columns in INFORMATION_SCHEMA.ROUTINES of course are based on.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply