Post reply

Is there a way to identify the last time a write happened?

  • December 6, 2005 at 6:16 am

    #91029

    There are tables in the database that I believe haven't been used in a long time.  I was wondering if MS-SQL stores the date of the last modification made to a table.  I know that the created date is stored in sysobjects.  Is there anything similiar for modifications?  The tables do not have columns with an updated/modified date. 

  • December 7, 2005 at 6:52 am

    #608156

    This is a question that has been often asked and the (sad) answer is "no"!

    Read a couple of these other threads for info on an external tool called dbghost...else, the disciplined version control way...

    t-sql version control

    modified database objects







    **ASCII stupid question, get a stupid ANSI !!!**

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

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