Top "Audit" questions

Best design for a changelog / auditing database table?

I need to create a database table to store different changelog/auditing (when something was added, deleted, modified, etc). I …

database database-design audit

Database design for audit logging

Every time I need to design a new database I spend quite some time thinking on how I should set …

database-design logging audit

MySQL auto-store datetime for each row

In MySQL, I'm sick of adding the columns dt_created and dt_modified (which are date time stamps for creation …

sql mysql datetime audit

Creating audit triggers in SQL Server

I need to implement change tracking on two tables in my SQL Server 2005 database. I need to audit additions, deletions, …

sql-server sql-server-2005 triggers audit

See what process is using a file in Mac OS X

I would like to be able to track a file and see which process is touching that file. Is that …

macos unix terminal audit lsof

Counting the number of deleted rows in a SQL Server stored procedure

In SQL Server 2005, is there a way of deleting rows and being told how many were actually deleted? I could …

sql-server tsql audit sql-delete

Entity Framework 6: audit/track changes

I have my core project in C#. I work on a database, where some tables have the columns "user_mod" …

c# entity-framework entity-framework-6 audit audit-trail

Implementing Audit Log / Change History with MVC & Entity Framework

I am building in a Change History / Audit Log to my MVC app which is using the Entity Framework. So …

c# asp.net-mvc entity-framework audit

Difference in Auditing and Logging?

I have been coming across these two words more often but i didn't see much difference in these? I mean …

java logging audit

When do triggers fire and when don't they

Pretty general question regarding triggers in SQL server 2005. In what situations are table triggers fired and what situations aren't they? …

sql-server database triggers audit