CODEWITHSUNDEEP
sql-serverlogging
Geoffrey
Geoffrey

Reputation: 5432

Is it possible to obtain a human-readable record of all transactions on a SQL Server database?

For example, a log that shows when which value was changed from what to what in which table, row and field?

Upvotes: 0

Views: 281

Answers (2)

Sankar Reddy
Sankar Reddy

Reputation: 1499

Apart from investigating a particular issue, its NOT recommended to use Transaction log for this purpose. There are many issues one in particular is reading from it when there are concurrent transactions which can cause access violation errors.

http://www.sqlservercentral.com/blogs/hugo/archive/2009/01/17/it-s-minus-twenty-five-outside-and-i-m-writing-about-transaction-log-files.aspx

As others have pointed out, roll out your own or use Change Data Capture (CDC) or Change Tracking (CT) if you are using SQL Server 2008 & above.

Upvotes: 4

Randy
Randy

Reputation: 16677

you are free to roll your own.

perhaps build a log table, and add triggers to record relevant transactions.

Upvotes: 1

Related Questions