Post reply

table/column change dates

  • August 18, 2008 at 1:06 pm

    #189495

    I've been a bit lazy and haven't kept track of some changes I've made. (I almost miss the old Ingres days. The UI for interacting with the db was so bad, you were forced to script everything. As a side effect, you always had the scripts around...) Is there any way to detect which tables/columns have been created or altered since a given epoch date? Presumably one can grab creations out of sysobjects, but I don't know where to pull the data for edit dates, and sysobjects seems a rather nasty beast (at least to me!) Thanks.

    --

    Shane

  • August 18, 2008 at 1:08 pm

    #859617

    Oops, forgot to mention that I have to do this on both 2005 and 2000. Thanks.

    --

    Shane

  • August 18, 2008 at 2:52 pm

    #859689

    This query:

    Select * from sys.tables

    will give you both create and modify dates. I do not believe that create and modify dates are maintained for columns.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • August 18, 2008 at 2:58 pm

    #859693

    SQL 2000 only keeps track of the create date.

    select crdate from sysobjects where xtype='U'

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 19, 2008 at 5:53 am

    #859930

    perils of SQL 2000, no modify date

  • August 19, 2008 at 8:38 am

    #860049

    Thanks, I guess I'll have to do it manually for 2000.

Viewing 6 posts - 1 through 5 (of 5 total)

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