Sharepoint 2007 - List ID Function

Question

I have read many posts that say the automatically assigned list ID number in Sharepoint 2007 does not change.
It is very important that the list items in my sharepoint site stay in the same order as when they were originally created. My initial image was that I could sort on the ID # to keep the list in order (since it wasn't supposed to change). It has not worked out. I have noticed that the ID changes and my data gets out of order.

Could anyone please explain to me how the automatically assigned ID # works in Sharepoint 2007? How/When is it assigned, reassigned? Is there an action that causes the # to change? When a workflow runs does Sharepoint reassign the item w another ID#? I do have several workflows running on this site.

Answer 1

A list item id is just like a SQL identity column. It is automatically incremented, is (or should be) unique within a particular list and doesn't change. Are you able to identify a point in your process where you are seeing an id change?

Answer 2

maybe you can take a look at the back-end sql server, there is no way you can manupilate it on user interface or object model as i know.