Post reply

how to get table 'design' modified history/log in sql server

  • January 23, 2014 at 11:10 pm

    #396154

    Hi All,

    I have started working on some application where some tables were designed earlier by some one else. But other users claim that the table's have got additional fields those have been added recently. I have no clue what previous developers have done.

    so please let me know how can I track if that certain table's DESIGN(added extra fields) have been modified and when.?

    any help would be appreciated.

  • January 24, 2014 at 2:00 am

    #1683026

    You can look in the default trace (several articles here on that), but it's very limited in how long it keeps things for. It keeps 5 files of no more than 20MB each and creates a new file every time SQL starts.

    Other than that, not unless you have custom auditing, change control or similar.

    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

  • January 27, 2014 at 9:04 pm

    #1683782

    Thanks a lot, That was really helpful .

    I was able to see who changed/altered the table.

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

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