Ms Sql Server 2000 Identity Columns Gaps

[liquidtox]

With regards to Identity columns in ms sql server 2000, what is the best way to manage the gaps after rows have been deleted?

I read somewhere about using :

DBCC CHECKIDENT (TableName, RESEED,1)
DBCC CHECKIDENT (TableName, RESEED)

But i think it only works if the rows are removed from the bottom of the table ... what about if the deleted rows are in the middle?

Or is it better to replace all identity columns with a regular Integer ID column (in which case where is the best place to generate the autoincrementing id number?)

tia.

 

[r937]

the best way to manage the gaps? ignore them

best by far -- very, very far

if you manage the identity numbers correctly, no one, including yourself, should even know the gaps are there

rudy

http://rudy.ca/