February 2, 2009 at 5:36 pm
I was wondering if it was possible to find out whether a table has been updated in Sql Server 2000? Does Sql Server keep logs of changes (add, delete, or changed/updated) records? If so, what system tables or stored procedures could I use to look up the changes? Thanks.
Stephen
February 2, 2009 at 7:01 pm
SQL Server 2000 has none of those features.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 4, 2009 at 1:12 pm
Although you cannot tell what happened before, you could add triggers to those tables you want to monitor and track the updates that way.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply