Change Primary Key from +ve Integer to -ve Integer

• Catcha

  SSC Eights!

  Points: 886

  More actions

  May 27, 2008 at 8:22 pm

  #191066

  Hi All

  In one of our table, the identity column is closed in reaching to maximum value allowed for integer data type. We proposed to change the identity seed to -2,147,483,648. We are currently using SQL Server 2000 for testing but SQL server 2005 for production. Will there be any different between both version? Is there any issues we need to be aware.

  Thanks in advance

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  May 27, 2008 at 8:47 pm

  #820936

  I did not have any issue.