General discussion
May 6, 2004 at 05:45 AM
jim.krale

MS SQL identity value being reset

by jim.krale . Updated 22 years, 4 months ago

We have multiple MS SQL 6.5 servers running and our issue is only occuring on one of the servers. When we reboot the server (or, I believe, when we stop/start the server services) the value for our IDENTITY classified fields gets reset to a previously used value and causes some duplication of record id’s or errors where the UNIQUE classification is used.

Any suggestions as to a cause and or solution?

Thanks in advance for your help.

This discussion is locked

All Comments