Can someone tell me where the IDGEN value in SQL Server can be found?

MarkP

Hi all,

Urgent!! I'm getting duplicate index errors and I see from previous posts that I need to re-set the IDGEN value to a higher number.
But... I cant find BAS_IDGEN or just IDGEN anywhere in my SQL Server databases. Not even BASDB or BASDBTEST.
Can anyone tell me where it is actually located so I can reset the number please?

PointsWell

Has your SQL Server been set to use sequences instead of BAS_IDGEN? I remember that Maria and SQL server versions were updated to stop using the IDGEN field for sequences. Can't remember if it is a default or if it is an option.

From reading other questions it looks like it is called BAS_IDGEN_SEQ

customaware

Assuming you have a seperate DB for the app.... Look for table bas_idgen_seq

You will not be able to directly edit this value.
So,
Park on it and run this following query, replacing 999999999 with the new value you want to set it to.

ALTER SEQUENCE BAS_IDGEN_SEQ RESTART WITH 999999999

Jaymer

from SSMS, select Properties and adjust values to your need

MarkP

Fantastic, thanks Jaymer.
That worked. All you need to do then is right click on it and select Properties, tick the Restart box and then the Restart number field becomes editable to let you input any number you like.

And since each database has its own BAS_iDGEN Sequence you can fix an individual database without affecting other databases.