Post reply

last insert date

  • July 6, 2013 at 4:27 am

    #295311

    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

    #1630222

    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

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

  • July 6, 2013 at 5:30 am

    #1630224

    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