SQLTeam.com | Weblogs | Forums

Sql server 2012 sequence using old values, please help

hi all,

thanks in advance, we are using sequences for number generation and primary constraint on that sequences, sequences are generating value eg.. 1, 2, 3, 4, 5,...
but at some of the point this sequence value is resetting to previously generating values like (1 / 2/ 3...) is reusing already generated values. in application no where we have mentioned the sequence to go back means (restart) . please suggest solution.

thank you,
sravan kumar.

Please check sequence limit
How sequence declared

If sequence max limit is 100
After 100 starts again from 1

Or
Default limit of sequence
In SQL server

Hope it helps