Automatic logging of modifications

I just stumbled upon your software and more specifically the Active Table Editor.
It sounds exactly what I’m looking for.

I want to have a simple way of basically having some coworkers to edit data directly in a SQL server table.
I have one question: Is it possible to create an automated log of the modifications made? So if someone modifies an e-mail address is it then possible to automatically create a record in a log file that says “<userid>,<date>,<time>,<database>,<table>,<fieldname>,<old value>, <new value>”.

Hello

Which version and edition of sqlserver have you got?

Mike

Hi Mike,

That is quick...
We're using SQL server 2008.
And we using edition Standard Edition (64 bit)

Regards,
Sander

I see.

There are several ways of doing it like using SQL server Change Data Capture ETC

In you case I think simple trigger as described here

www.simple-talk.com/sql/database-adminis...-on-the-audit-trail/

Should work perfectly

Mike

Thanks for this, sounds like the way to go indeed and no need for supporting this in Active Tabel Editor then.
I'll have team install and look at the demo version to see whether it is a product then that we can use.
Thanks again!

Thank

If you find a way to improove our software please let us know

Mike