Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
teamjai
Yak Posting Veteran
52 Posts |
 Posted - 2015-04-09 : 02:39:42
|
| i need to find the history in SQl server.i need to find the data, When was data last inserted/updated/deleted in a specific table?. is it possible?Table name: Employeeplease help me. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-04-09 : 08:44:02
|
| It is possible if one of the following is true:1. You use Change Data Capture2. You have a trigger on the table that writes to a secondary table whenever inserts/updates/deletes occur and adds a timestamp |
 |
|
|
|
|
|
query for find data last inserted in a table