Post reply

Script Need for find last date insert record

  • August 9, 2011 at 10:55 pm

    #104085

    Hi,

    In SQL Server 2000 with SP4.

    could anyone give me script for How to identified last date inserted record in table? Table does not have date column.

    Thanks

    ananda

  • August 10, 2011 at 12:15 pm

    #1366804

    If you don't have a datetime column in the table in question holding this information and there is no kind of auditing (e.g. capture data modification in a separate table using a trigger) then there is no simple way to get the information you're looking for.

    You might be able to analyze the transaction log files using a 3rd party tool.

    Keep in mind: one purpose of a table is to store information for future use. If you don't store the date in a column, you're basically not planning to use this information later on.


    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]

Viewing 2 posts - 1 through 1 (of 1 total)

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