Post reply

Table History

  • August 20, 2004 at 9:34 am

    #161410

    Hey,

    I'm sure my questions must seem a little silly...that's why I'm posting in the Newbie Thread....

    Is there a way to view a table's history in SQL Server? By history I mean dates it was updated or deleted and re-populated..

    The properties only give the creation date...

  • August 23, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • August 23, 2004 at 4:48 pm

    #520259

    No, if you need that kind of information, you would need to set up an audit table and populate it with a trigger.

    Steve

  • August 24, 2004 at 7:45 am

    #520324

    Hey Steve,

    Thanx, I thought maybe there was a built-in feature I didn't know of...

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

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