p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

proasp_codeclinic thread: identity columns in sql server

Message #1 by edmundcs@m... on Fri, 17 Mar 2000 11:27:29
the problem is not with the code. its by design. 
whenever a failed db transaction rolls back, 
the seed value of the table involved having an 
identity column is not reset, as such that value 
is lost. so, i guess the issue here is, is there
any other way (apart from using identity columns) 
i can maintain an ordered number of records in a
table ?

  Return to Index