Tracking events

I would like to know when somebody selects/update/insert data on some
of my tables.
What is the best practice for this scenario?
I thought to create new audit from security tab in Managment studio
and define new database audit specification.
All audit data I would write to file(I guess it is not possible to
write to some table).

I guess this is much better than writing triggers or using sql server
profiler trace data?
Is there some url with best practice for this scenario?

I have SQL2008 enetrprise server.

Thank you for your suggestions,
Simon

On 25 jan., 10:51, simon wrote:
> I would like to know when somebody selects/update/insert data on some
> of my tables.
> What is the best practice for this scenario?
> I thought to create new audit from security tab in Managment studio
> and define new database audit specification.
> All audit data I would write to file(I guess it is not possible to
> write to some table).
>
> I guess this is much better than writing triggers or using sql server
> profiler trace data?
> Is there some url with best practice for this scenario?
>
> I have SQL2008 enetrprise server.
>
> Thank you for your suggestions,
> Simon

I found out that on production I have standard version of SQL2008,
which doesn't support auditing.
What is the best alternative to achive the auditing, trigger or trace
file and if trace file, how?
I need to audit insert, update and delete statements on some of the
tables.

Thank you,
Simon