Home Forums SQL Server 2008 SQL Server 2008 - General IDENTITY value becoming too big RE: IDENTITY value becoming too big

  • March 22, 2013 at 6:15 am

    #1599733

    You can use DBCC CHECKINDENT to reseed identity value.

    DBCC CHECKIDENT ('Production.Product' , RESEED, 1001)

    Vishal Gajjar
    http://SqlAndMe.com