Identity column: what happens when it runs out?

From: Adam Clauss (cabadam_at_nospam.tamu.edu)
Date: 01/22/05 

Date: Sat, 22 Jan 2005 15:22:22 -0600

I have a table containing an identity column (bigint) as its primary key.
The table will have very frequent insertions/deletions from it.

Many items will be added, but they aren't really expected to be there for
long. I can never expect that the table is empty, however.

So, eventually, the new ID's that get added will increment up to the maximum
bigint value. What happens then? Does it automatically wrap and start
over?
If it starts over, how does it handle any values that may still exist?

How should I handle this?

Thanks! 

-- 
Adam Clauss
cabadam@tamu.edu

Relevant Pages

  • Re: Identity column: what happens when it runs out?
    ... > I have a table containing an identity column (bigint) as its primary key. ... > The table will have very frequent insertions/deletions from it. ...
    (microsoft.public.sqlserver.programming)
  • Re: Identity column: what happens when it runs out?
    ... >> I have a table containing an identity column (bigint) as its primary key. ... Adam Clauss ...
    (microsoft.public.sqlserver.programming)
  • Index Question
    ... I have a 500,000 record table with the primary key being a bigint ... identity column. ... I have another column (smallint) that it is not ...
    (microsoft.public.sqlserver.server)
  • Re: MS Access 2007 closes and errors when clicking on last record
    ... I have adp's in use with BigInt primary keys and foreign keys, ... Was BigInt a feature introduced with SQL 2005, or it existed in SQL 2000? ... Sylvain Lafontaine, ing. ... >> the primary key or creating the new records if more than one table is ...
    (microsoft.public.access.adp.sqlserver)
  • Problem reciving xml element
    ... CONSTRAINT Soknadsskjemaer_pk PRIMARY KEY ) ... ID bigint IDENTITYNOT NULL, ... CREATE TABLE Checklister ...
    (microsoft.public.sqlserver.xml)