July 6, 2013 at 4:27 am
Hi,
My question: i have database emit046 here i need all table last insert/update/deleted date time information required.
please help.........
thanks in advance
immad
July 6, 2013 at 5:18 am
That information is not stored anywhere. If you need that, you need triggers on the tables, a trace, CDC, change tracking or maybe SQL Audit, depending on exactly what you want.
You can use the index usage stats DMV to get the last change to an index since SQL was started, but it does not differentiate between insert, update or delete and the information does not persist across a service restart
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2013 at 5:30 am
ok thanks
immad
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply