Showing posts with label crdate. Show all posts
Showing posts with label crdate. Show all posts

Sunday, February 19, 2012

Get Modified datetime of an DB Object in SQL-Server 2000

Hi Wizzies,
Plz help me with this one. I know that I can get the CREATION datetime of a database object from "crdate" column of sysobjects table. Same way, is there anything in SQL-Server 2000 for fetching MODIFIED datetime of a database object?Not that I know of. In the past I've run nightly jobs against the database that compare current stored procedure CHECKSUM values against previous values to see if any were changed.

blindman