Finding NEWLY inserted records..

[rasprer]

I have a huge problem. I need to find a way to retrieve 'Newly' created records from the table. The table DOES NOT have any datetime fields I can reference nor do I have a field that is defined as an identity column.

Is there anyway that I can retrieve these new records..Say..I write a program to find all the records in the table at 2m. Then I stop the program, and run it again at 3m. Now I need all the data from 2m - 3m.

Note...I cannot create any fields in the database nor any table.

Please assist...

 

[jgoodman00]

The only thing I can think of is profiler. You would then be able to see inserts updates etc, but it would be far better to add a single column to the table which logs the creation date...

James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures