Autonumber and Compact

  • Thread starter Thread starter helpseeker
  • Start date Start date
H

helpseeker

Hello:
As I recall, if a table has no records and a database compact occurs, the
identity seed for the table gets reset to 1
Correct?

I do not want the identity seed to reset to 1 when the database is
compacted. Any ideas?

Thanks for your help
helpseeker
 
Back
Top