Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

last insert date Expand / Collapse
Author
Message
Posted Saturday, July 6, 2013 4:27 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 12:05 AM
Points: 99, Visits: 304
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
Post #1470909
Posted Saturday, July 6, 2013 5:18 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:02 AM
Points: 42,998, Visits: 36,154
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1470913
Posted Saturday, July 6, 2013 5:30 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 12:05 AM
Points: 99, Visits: 304
ok thanks
Post #1470915
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse