Post reply

DB Objects Last Edited Date

  • January 10, 2005 at 5:39 pm

    #102343

    I can't determine if SQL Server stores the "Last Edited" date for objects on the database.  The crdate column in sysobjects is obviously the createdate, is there a last edited date stored by SQL Server?

  • January 11, 2005 at 2:38 am

    #536760

    No, there is no built-in date. I think there are third-party tools that can do this. The crdate is indeed the creation date and it will also serve your purpose as long as your editing consists of DROP and CREATE. If you use ALTER the crdate remains unchanged.

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

  • January 12, 2005 at 3:49 am

    #536983

    Utilize your source control to store your DDL statements which are changed - then you have a complete audit trail. This is the best method I know - our software incorporates this approach taking any guess work out of database developing, deploying and auditing.

     

     

    regards,

    Mark Baekdal

    http://www.dbghost.com

    +44 (0)208 241 1762

    Database change management for SQL Server

     

     

     

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

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