Discussion Locked
MS SQL identity value being reset
0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.