SQL Server Triggers for Audit Log

Need INSERT, UPDATE and DELETE triggers for two tables.

A record should be written to the table named tblAuditLog for each column that is modified in the two tables (named:tblCommissionExpected and tblCommissionSplit)

Identity columns are excluded fro being written to the audit log. Also, CreatedOn, ChangedBy and ChangedDate columns are not written to the audit log.

Only columns that change need to be written. When multiple rows are changed, each changed value in each row must be written to the audit log.

When a column is "char" type the old and values should be written to "OldCharValue" and "NewCharValue".

When a column is "smalldatetime" the old and new values are to be written to "OldDatetimeValue" and "NewDatetimeValue".

When a column is "varchar" type the old and values should be written to "OldCharValue" and "NewCharValue".

.... and so on .................

Inserts will have no OldValue (NULL)

Deletes will have no NewValue (NULL)

DDL for the tables is supplied in attached file.

## Deliverables

1) Complete and fully-functional working triggers in SQL Script form.

## Platform

Microsoft SQL Server 2000

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Veja mais: sql server 2000 audit log, php script null, on audit, audit file, SQL Server, sql server c, sql script , sql microsoft, MICROSOFT SQL SERVER, IS audit, c sql server, sql audit table, update sql file, rows insert, server log, sql audit tables, php sql 2000, update insert sql, insert sql, php sql update

Acerca do Empregador:
( 25 comentários ) United States

ID do Projeto: #3169609

Concedido a:


See private message.

$29.75 USD em 5 dias
(10 Comentários)

2 freelancers estão ofertando em média $40 para esse trabalho


See private message.

$51 USD in 5 dias
(7 Comentários)