It's possible to see how the data in the table looked at a previous moment.

The table being defined as:

create table MyTable (

a int not null primary key,

...

I don't think it's a good idea to audit ALL tables in the database.

For the most important tables (which usually are small so the overhead is minimal), I use the...