Does the CDC feature not meet your needs?
The best way to do this is at the database level since it will record all
the changes people might make directly on the database, bypassing the
application. You can supplement this using extra code at the application
level, such as passing in the user name
You could use triggers it may have an impact on the database though.
Another option would be to create stored procedures for doing all of your
updates and deletes. You could then copy the original rows into another table
with a flag saying a delete or update as well as who did it and when. Aft
2 matches
Mail list logo