sql 2008 metadata modified date

Is there a way to identify the timestamp when an object(table/view/stored proc...) was modified ?

there's a refdate in sysobjects but it's always the same as crdate atleast in my case and i know that alter view/alter table/alter proc commands have been run many times post creation

Answers


modify_date in sys.objects:

Date the object was last modified by using an ALTER statement. If the object is a table or a view, modify_date also changes when a clustered index on the table or view is created or altered.


Need Your Help

Looking for network link speed determination algorithm

networking ethernet

I'm looking for the best way to interpret the standard (well, standardish) Ethernet PHY registers, to determine the speed that an Ethernet link is actually running at. (e.g. 10/100/1000 and full/h...

css for mozila and css for chrome

css google-chrome mozilla

I would like to ask about a centering problem i have with a <p> on mozilla and firefox. You know, it looks nice on chrome but not on mozilla.