SQL change log monitoring

giulio.cipo
giulio.cipo Member Posts: 77
edited 2005-02-04 in NAV/Navision Classic Client
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

Comments

  • watung
    watung Member Posts: 29
    Have you tried SQL Profiler (included in the SQL Server package)?
  • giulio.cipo
    giulio.cipo Member Posts: 77
    I could do it for the future but i wuold like to analize the past
  • watung
    watung Member Posts: 29
    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).

Categories