Is there a "date modified" field

Question

Is there a "date modified" field

DanaH1976

Ten Centuries

Points: 1046
More actions
November 6, 2003 at 6:46 am

#82538

I'd love to be able to see when a table or stored procedure was last modified. Is there such a field (there is a "date created" field) and how does one get to it?

Dana
Connecticut, USA
Dana

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeremy Kemp SSCertifiable Points: 6754 More actions · Answer 1

Try Bill Wunder's archive utlitity (available in Products|Freeware). It scripts the items out to disk and into Visual Source Safe. If there are any changes then these get records in VSS.

I'm not aware of anything within SQL Server which would tell you this information.

Jeremy

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

quote:
I'm not aware of anything within SQL Server which would tell you this information.

unless you want to go for C2 auditing

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Michael S. Armentrout Ten Centuries Points: 1178 More actions · Answer 3

Not when, but you can tell that an object was modified based on the base_schema_ver column in sysobjects. The only benefit is derived when you compare current to prior to determine that a change occured - you still can't implicitly tell what changed though.

We use this and take a snapshot of sysobjects at midnight and compare its' results to sysobjects at say noon. Based on the base_schema_ver, we can tell a change occured. Again, that is all we can tell.

Hope this helps.

Be great!

Michael

Be great!
Michael