0

How do you find the modification history for a certain table / row in SQL server 2000? Thanks.

Taylor Leese
  • 51,004
  • 28
  • 112
  • 141
Stan
  • 37,207
  • 50
  • 124
  • 185

1 Answers1

1

you need to get a product that can read the transaction log like SQL Log Rescue or Apex SQL Log

SQLMenace
  • 132,095
  • 25
  • 206
  • 225
  • Is there anyway to examine the transaction log without 3rd party tools? – Stan Jun 09 '10 at 23:07
  • What about in transaction log in SQL server 2005/2008? Do they need 3rd party tool to examine? – Stan Jun 10 '10 at 07:31
  • Yes. Basically, it not a part that people normally access. If you want to track changes, put in triggers that write to a change history table, or use the 2008 change services. – TomTom Nov 02 '10 at 20:52