Database Tracking Tools

[ABerkowicz]

Hi - Does anyone know of any SQL tools to be able to track & capture any database (data only) changes that have been made through enterprise manager and/or query analyzer?

 

[ptheriault]

Nothing that I've heard of. Usually most DBA's just create audit triggers to track changes to data that they deem important.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[nomadicalloy]

Good answer ptheriault. Visual studio Team System has some tool to track schema changes. Also you can look at following (not free)

http://www.idera.com/Products/SQLchange/

This is Signature

http://www.xpherion.com/

 

[mrdenny]

Normally I would simply look in the transaction logs using Lumigent's Log Explorer or something like it.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com