Re: Audit trail while in Transact SQL

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Eric Sabine (mopar41_at____ho_y_tmail.ScPoAmM)
Date: 05/18/04 

Date: Tue, 18 May 2004 14:32:32 -0400

You could use stored procs to capture new and old data and save it to an
audit_trail table, you could use triggers too. Lumigent makes an auditing
tool which I have not used but often see it linked. Likewise, they make log
explorer which is very well respected.

hth
Eric

"Joe" <jkearney@icisolutions.com> wrote in message
news:eb9301c43d05$35a62bf0$a101280a@phx.gbl...
> Is there any way to set up Transact SQL to start an audit
> trail and the close it out when the update is done?
> I need to do this update remote and I am using Query
> Analyzer so I wanted to set up a Trigger to catch all
> updates that are done to the table I am updateing. This
> will allow me to go back and check out the info against
> what I wanted to do.
>
> As it is now I get the message 1234 rows updated and I
> want the details of the rows.
>
> Thanks
>
> jk
>
>
> >-----Original Message-----
> >Profiler is a tool that allows you to "watch" statements
> as they are submitted to the server. You can find this
> tool within the SQL Server program group. Does this tool
> provide the information that you want?
> >
> >--
> >Keith
> >
> >
> >"Joe" <jkearney@icisolutions.com> wrote in message
> news:ec2d01c43cfe$1a5f7600$a501280a@phx.gbl...
> >> Is there any way of makeing an audit trail while in
> >> Transact SQL? Meaning if I make a large amount of
> >> changes with an update command is there a way to
> capture
> >> these changes in a text file or something to review
> later?
> >>
> >> So I can make sure of everything that was changed?
> >>
> >> Thanks
> >>
> >> Joe
> >.
> >

Relevant Pages

  • Re: Business Objects performance
    ... One possible approach might be to capture some of the relevant ... information using a combination of a logon database and logoff ... database set of triggers and some custom logging code somehow. ... Of course we all know that triggers are evil. ...
    (comp.databases.oracle.server)
  • Re: how to trigger Back event
    ... no I want to "capture" this event in my asp.net page... ... So the user clicks on the back /forward button in his browser and that ... triggers an event in an asp.net page?? ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Audit trail while in Transact SQL
    ... Profiler is a tool that allows you to "watch" statements as they are submitted to the server. ... You can find this tool within the SQL Server program group. ... > changes with an update command is there a way to capture ...
    (microsoft.public.sqlserver.programming)