Post reply

Record entered date

  • January 16, 2008 at 7:45 am

    #185448

    Hi all,

    Is there a way in SQL Server to find out the date when a record was entered. I have an old database which does not log any timestamp.

    Thank you.

  • January 16, 2008 at 7:48 am

    #768664

    There is only if the database is set up to record (in a column) the time the data was entered. It's not an uncommon thing, but I'm assuming you don't see a "dateCreated" (or something with a similar name) column, or you wouldn't be asking....

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • January 16, 2008 at 7:55 am

    #768670

    Matt,

    Thank you for your prompt response. There is no timestamp on any of these tables, so I do not know when the records were inserted. I am trying to import data from these tables into my local sql server but since the database is large I can only import last 2 months worth of data into my local. Can this be done without having any timestamp on the record?

    Thank you.

  • January 16, 2008 at 8:11 am

    #768691

    Unless you have a column that stores the date inserted, or an audit trail that records data changes and dates, there is no way to identify when records were inserted or in what order.

    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

  • January 16, 2008 at 8:13 am

    #768697

    Thank you.

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

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