March 5, 2008 at 7:44 am
Hello,
Is there any system table or any other system object/properties where i can check the date where a specific object was changed.
Imagine that someone add one column to a specific table, where can i get information of field that was added and date it changes?
Thanks and regards,
JMSM 😉
March 5, 2008 at 8:28 am
If you leave the default trace running (on by default), you can view a built in report. Right click database -> Reports -> Standard Reports -> Schema Change History.
Yet if you have a highly utilized server, this data will not go to far back, as it only reads from whatever is captured in the default traces.
You'd be better off purchasing software that tracks such things. There are a few products out there, but my personal recommendation is to use Bill Wunder's DDL Archive Utility, which basically takes a snapshot of all objects against a specified server, at a target time. The objects are scripted out via DMO and then checked into source safe if there is change. He is currently working on a new version to support all new 2005 objects and removing the dependency on VSS.
There are some other products out there that perform similarly ... I believe Idera makes a decent one. Really depends on what your objective is.
March 5, 2008 at 12:47 pm
Wel-l-l-l-l-l.... kind of...
Sys.Objects has a Modify_Date column on it so you can tell when the last change occurred... you just can tell what the change was.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply