New answers tagged

0

You can configure SQL Server Auditing (Server and Database Audits), you have the ability to audit CRUD operations as well as other activity. One warning is to be aware of how much data you are auditing, logs fill up fast.


0

I had once used a logging mechanism on master data tables from different databases on a server illustrated at SQL Server Log Tool for Capturing Data Changes Unfortunately, this method creates SQL triggers on tracked db tables, so it might affect the performance in a negative way when compared with CDC. If the tables or the transactions on tables which you ...


0

First off, don't try to do it manually. It's harder than you think. Honest, just don't. CDC is really useful for data capture, for event handling etc. However, you really should use Replication here. I have a replicated database to over 150 warehouses and it works well. One thing I would strongly recommend is you use a VIEW for your replication filtering. ...



Top 50 recent answers are included