Re: Identifying Updates, Deletes and Inserts

Richard

If you want to see the old and new values, triggers are the only approach you can use unless you can code it in your application in some way. Auditing is the other approach taken, but it just tells you that a table was changed, not the columns or the key values.

Pete

Richard Perks wrote:

> I would like to know if there are any ways, other than the use of triggers,
> of identifying when an update occurs on a database. The sort of information
> I need to get would be table name, column(s) that have changed and keys to
> the row.
>
> Any help is very much appreciated.
>
> Regards
>
> Richard

--
Regards

Pete

Received on Mon Jul 26 1999 - 11:18:58 CDT