How to find recent sql update operations affecting a specific table (SQL Server 2005)

Question

say I want to find the last added rows (UPDATE by any user, not necessarily the one doing the UPDATE) in table XX.

0

Flair 19 nov. '08 at 5:19

3 answers

Mitch wheat · Answer 1 · 2008-11-19T05:40:24+0000

You will need a transaction log reader. There are several free as well as commercial offers.

You can also try this undocumented command:

 DBCC LOG(<database name>[,{0|1|2|3|4}]).

If you are using SQL Server 2000, RedGate has a free tool called SQL Log Rescue .

EDIT: Documentation for DBC LOG: (1) (2)

shahkalpesh · Answer 2 · 2008-11-19T05:38:13+0000

Refer to the SQL docs and find the OUTPUT clause (which you can use with UPDATE / INSERT to get the affected records).

TGnat · Answer 3 · 2008-11-19T14:24:06+0000

SQL Server Profiler will allow you to track database accesses in real time. You can set filters on a number of properties to get the result you want.