SQL change log monitoring

giulio.cipo

hello,

I would like to monitoring what do a user and the database server is SQL, how i can see all the field and the table modifing by him.
I know that there is a log file where i cas see it in sql (i don't want use navision change log) but i don't know sql well.
There are some one that know how to do ?

Thanks

watung

Have you tried SQL Profiler (included in the SQL Server package)?

giulio.cipo

I could do it for the future but i wuold like to analize the past

watung

giulio.cipo wrote:

I could do it for the future but i wuold like to analize the past

That means you need to get access to transaction logs. I don't think there's a built-in utility in SQL Server. 8-[ You need a third party tool like Log Explorer (Lumigent).