Topic: Sincerely ask: How to find the date when the data of table is last modified (insert,update,delete) if i do NOT do anything special? is this true? http://en.allexperts.com/q/MS-SQL-1450/SQL-database-table-data.htm @华人论坛:枫下论坛 The Rolia Forum of

工作学习 / 科技领域杂谈 / Sincerely ask: How to find the date when the data of table is last modified (insert,update,delete) if i do NOT do anything special? is this true? http://en.allexperts.com/q/MS-SQL-1450/SQL-database-table-data.htm -elecskunk(elecskunk); 2007-12-11 (#4114245@0)

1 No way; 2 Not completely true -- Timestamp can only track last update date. In order to track delete, you need to use triggers. -piglet(迪斯尼fan); 2007-12-11 (#4114914@0)
It's true. Every data operation is recorded in log file. Howevery, without special tool, you cannot get data from the log file. -deep_blue(BLUE); 2007-12-11 (#4114924@0)

Thank you two. But, this seems a slim of hope. My case is a live project suddenly require those information. i am just interested what was the very last time some tables were modified. Doing research on DBCC LOG now -elecskunk(elecskunk); 2007-12-12 (#4115605@0)

@