Post reply

Identity reused problem

  • March 12, 2007 at 9:32 am

    #116248

    I have a table with id an identity column.

    Can I forbid the identity column of taking the same values of deleted ones?

    How can I resolve this issue?

  • March 12, 2007 at 11:33 am

    #694449

    If it is set up as an identity then it should never be re-used, unless DBCC Checkident is run against the table with reseed option set.

  • March 13, 2007 at 1:03 am

    #694586

    If I move the database into another server, also the identity wont be reused???

  • March 13, 2007 at 8:13 am

    #694698

    An identity column always increments by the SEED value. It doesn't matter which server the database is on. That's like having a VARCHAR(10). You can move the database wherever you want...it will always be VARCHAR(10) unless you change it. IDENTITY is a property of the column, not the table, database, or server and will always keep its SEED value, unless you change it.

    -SQLBill

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply