Post reply

Get date/time for each record inserted in a table

  • January 28, 2010 at 9:35 am

    #94420

    Hi friends,

    This is a problem faced by the development guys at my workplace.

    suppose you have about 50 records inserted in a table at different intervals of time.How do you retrieve the date/time of individual rows inserted or updated in the table if you do not already have a created_date column showing the date of the corresponding record...Like does sql server have hidden date recorded somewhere corresponding to a row inserted or modified in a table and if so how to retrieve it??

    Thanks...

  • January 28, 2010 at 10:03 am

    #1110179

    The only place I can think of would be the transaction log file.

    Other than that: AFAIK there is no hidden date recorded.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • January 28, 2010 at 9:40 pm

    #1110447

    In that case could you suggest some method to retrieve that date from the transaction log for each row??........I tried dbcc log...but that wasnt much help..or rather i couldnt make out anything.....

    thanks for the help

  • December 27, 2011 at 1:58 am

    #1425608

    can you give me the query for getting date for each record inserted in a table?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply