Change Data Capture Tool

(Aaron Willett) #1

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.

(Jose C Gomez) #2

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.

(Aaron Willett) #3

What is it? An editor of sorts?

(Jose C Gomez) #4

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