none
Is there any way I can trace the changing of value in a table? RRS feed

  • 問題

  • Hi,

     

    Can I trace the user who have changed the value in a table in a database? The user is using the access database mde to connect to the SQL server.

     

    The Profiler can only check the user logged in time, execute Select command, but can not shown changing from one value to another.

     

    Please help. Thanks.

    Patrick

     

    2008年10月29日 上午 09:43

解答

  • Did you choose correct event to trace in profiler? It should be able to catch that. Other other options are:

    trace it with third party log read tools or sql auditing tools;

    put trigger on tables to trace all data changes.

    2008年10月29日 下午 04:40