Change Data Capture Tool

Can anyone recommend a good Change Data Capture tool?
We’re running the standard version of SQL, so we do not have access to the one packaged.
We’re looking for a simple way to capture adds/updates/deletes on database tables that we specify–bonus points for being able to narrow it down to a specific user and then be able to report on it.

Checkout the Red gate SQL Server tools

I think they include a change capture stuff, red gate is pretty awesome in general. SQL Prompt is a must.

What is it? An editor of sorts?

Is a plug in to SQL Studio that does a bunch of really nice stuff. It enhances SQL management studio

2 Likes