Post reply

Value of identity-based primary column reaches max

  • December 9, 2006 at 7:34 am

    #116519

    Hi,

    What if value of numeric-identity-based column reaches max?

    In details, for example, I have a table and choose a primary column called “RowID” as INTEGER and its values are provided using identity (1,1) when the table is created. Day by day, rows of the table keep growing and when the value of primary column reaches MAXIMUM value of 2,147,483,647 or 2^31-1, I cannot insert more rows afterwards in the table because no more value available or > 2,147,483,647 can be assigned for RowID column???

    Thanks

    Johnsql

  • December 9, 2006 at 9:16 am

    #677119

    EDIT

    Planning solves this problem because you define it as Big INT but SQL Server will only use Big INT when the values of INT is used up. Try the link below for details.   I forgot to add in your application SQL Server will not accept or return  big INT until you use up the INT values. Hope this helps.

    http://msdn2.microsoft.com/en-us/library/ms187745.aspx

     

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 1 (of 1 total)

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