MySQL Log Queries To File
Activate (and deactivate) log queries to file.
set global log_output = 'FILE';
set global general_log_file='/path/to/file.log';
set global general_log = [1|0];Audit
MSSQL Create Update Trigger (QuickRef)
A basic update trigger. This specific trigger can be used for audit purposes.
CREATE TRIGGER dbo.TriggerDesc_UPDATE ON dbo.TableName FOR UPDATE AS BEGIN IF UPDATE(ColumnName) BEGIN INSERT INTO dbo.AuditLogTable (IDColumn, OldValue, NewValue) SELECT i.IDColumn, d.Value, i.Value FROM inserted I JOIN deleted d ON i.IDColumn = d.IDColumn END END