Clustered Index, Insert Sequence

[TheGreenOne]

Does SQL Server 2000 tag records in a table with anything to indicate the sequence that the records were inserted?

I have a clustered index on this table.
I understand that as records are added they are not appended to the end of the table, but inserted into the table according to the clustered index.
Now I need to know what sequence that the records were added in. Its too late now to add a sequence column.
I know its a strech, but does sqlserver store, behind the scenes, any information that might help me?
If not the sequence, perhaps the modification date.

I've been searching through the online books, but have not found anything yet. All comments appreciated.

 

[fluteplr]

You are out of luck.

There is no way to tell the insert sequence unless you have set a datetime field to record the time it was inserted or an identity field that will automatically increment.

 

[TheGreenOne]

Bummer,
No other replies, I'm still hoping???

 

[JamesLean]

What are you hoping for?! fluteplr has pretty much summed up your chances I'm afraid.

--James

 

[SQLSister]

Your best bet here is to set up a system to collect this information in the future. Then go to your boss and tell him that the other task cannot be done as it was a new requirement and the database was not set up to collect the information for the existing records, but you have figured out how to collect the information in the future.

 

[TheGreenOne]

It's not what I wanted to hear, but thanks anyway.