data-change

Logging every data change with Entity Framework

There is a need from a customer to log every data change to a logging table with the actual user who made the modification. The application is using one SQL user to access the database, but we need to log the "real" user id. We can do this in t-sql by writing triggers for every table insert and update, and using context_info to store th...

Is there some database-independent way get data change notifications at the field level?

Currently, using SQL Server 2005, I poll a "windows events" database to determine changes in a table called WINDOWS_EVENTS, which has a timestamp field. Looking at the timestamp I can determine if the row changed, but not what field in that row changed. Is there some generic (i.e. database independent way) to detect field level changes?...