Audit trails for changed records

From: Sue (slevene@connix.com)
Date: 08/08/02 

From: "Sue" <slevene@connix.com>
Date: Thu, 8 Aug 2002 07:47:29 -0700

Hi I am using SQL 7.0 and MS Access. I would like to be
able to log to a table information whenever a record is
changed.

What's the best way of doing that?

I can track the transactions with the profiler by tracing
all RPC:completed events with the txt begining with
sp_executesql.

I would like to have the info in a table I can view in
access.

Relevant Pages

  • Re: sql profiler newbie
    ... The profiler GUI will definitely have an impact when monitoring a production ... The degree of impact will depend on what events you are tracing. ... option to save the trace as a SQL Script, and then run the trace totally on ... the server, storing the results in a file. ...
    (microsoft.public.sqlserver.setup)
  • Re: Auditing user login - for only certain apps
    ... Yes - and SQL Profiler will do what I need. ... client side tracing - which I definitely don't want to do. ... client or server side. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Profiler
    ... > ich verwende SQL Server 2000. ... > die mir mit SET STATISTICS ON; ... > Ich habe im SQL Profiler unter "Leistung" Execution Plan, ...
    (microsoft.public.de.sqlserver)
  • Re: ADO.NET query execution much slower than SQL Management Studio
    ... Stats being compiled on SQL Server ... If you are dynamically adding statements in a sproc, ... compare this to the profiler command (meaning what is actually run in the ... Duration: 440 ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SSAS2005 and ADOMD : update cube problem
    ... The Profiler on AS shows a '14 - CommitTransaction' event with following ... The Profiler on SQL shows different Insert events into the WriteBack table ... >> Exit Sub ...
    (microsoft.public.sqlserver.olap)