Record change

[R7Dave]

Hello

Is there a way to tell which table and which records in a database have changed using the transaction logs?

Do I need to purchase software to do this or can it be done with T-SQL?

Thanks
Dave

 

[mrdenny]

There are some undocumented commands which are unsupported which can do this. However on a busy system you could be talking about dumping tons of data. Products like "LightSpeed for SQL Server Enterprise" make the job much easier.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog