SQL Server Performance

DTS Audit reports

Discussion in 'SQL Server DTS-Related Questions' started by alpossp, Mar 21, 2006.

  1. alpossp New Member

    We are building DTS packages that will run in jobs and delete or insert records. I am looking for a way to include audit reports (when desired). In other words:

    When the audit swith is on

    1) Delete records
    2) Print Deleted record report
    3) Insert records
    4) Print Insterted records report

    When the audit switch is off

    1) Delete records
    2) Insert records

    If I remember right records are only marked delete until work is committed. So I think we need to somehow turn autocommiit off run the delete, execute are select against "deleted" items, then commit? I am very rusty but I remember there are some capabilites like that. Any help would be appreciated.


Share This Page