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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2011-05-31 : 23:05:32
|
| Dear All,I want to know any last records table modified (INSERT/DELETE/UPDATE) in a table of the DB having 50 tables.I want to know any table inside data has been modified ?We don't have any audit trial.Does SQL server 2005 having any function to know this last 50 or n records modified objects, i mean i don't want to know the records modified instead if i know which table is modified will be helpful.Thanks,Gangadhara MSSQL Developer and DBA |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-06-01 : 16:11:00
|
| You need a column in each table that identifies when that row was modified. Usually this would be a last modified date column as well as a last modified by column.Without that - there is no way to identify which rows were updated and when.Jeff |
 |
|
|
|
|
|
Last data modified in a database