Post reply

Objects Changed Since X Date?

  • March 11, 2005 at 7:40 am

    #185491

    I am looking for a modified date or something similar in system tables so I can identify objects that have been changed (altered/saved/created) since a specified date.  The create date is easy enough, but I am not finding a last modifed date?

    Anyone know of such a thing?

  • March 11, 2005 at 7:57 am

    #546621

    I just found and SQL FAQ on the net that seems to confirm that there is no modified date.  The suggestion there was to drop the proc and recreate it to trigger the created date instead of using ALTER statements.

    That makes enough sense.  I'll just use that method moving forward.

Viewing 2 posts - 1 through 1 (of 1 total)

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