There was a number sequence which was configured as sequential & now it has exhausted its limit.
Is there any way i can find the unused number sequence of this NS & reuse them.
Also any other suggestion on how to resolve this situation .
*This post is locked for comments
What do you mean by sequential? Number sequences are sequential by definition (unless you set it to Manual but then it's not using any numbers at al).
The easiest solution is just to increase the length of the number sequence (add one more digit). That way you will have 10x more numbers available. If this is ok in your situation then it's the correct procedure to resolve the issue.
About your question - you can write a job that goes through the table where the number sequence is used, and searches for gaps (=unused numbers). Then it would insert these unused numbers in the "Status list" of your number sequence. Finally, set your number sequence to Continuous, and it will start using the numbers from your Status list.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,818 Super User 2024 Season 2
Martin Dráb 229,147 Most Valuable Professional
nmaenpaa 101,156