Post reply

Is it possible to find which tables were updated on a given date?

  • August 18, 2008 at 4:18 am

    #191166

    Is it possible to find which tables were updated on a given date? I've a SQL 2000 server database of which I'm one of a few people that look after it, I just wondered if there was a query I could run that would tell me if any databases had been added to or ammended on a given date

  • August 18, 2008 at 7:42 am

    #859441

    No, the file itself has a timestamp, but that changes regularly. Changes to tables aren't tracked.

    You could set up a datetime mark in each table and have it updated with the current date and time when an update/change occurs, but you'd have to do that in advance.

  • August 18, 2008 at 7:45 am

    #859444

    Thanks Steve, I thought that might be the case. I just wondered if the server itself kept tabs on what was happening. Oh well, back to the drawing board!

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

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