• Hi

    You reseed the identity columns with the following command

    dbcc checkident('YourTable',reseed,reseed_value)

    you can set the reseed_value = -1 and the identity starts from -1, otherwise it by default starts from 1.

    Reference http://technet.microsoft.com/en-us/library/aa933196(v=sql.80).aspx

    Igor Micev,My blog: www.igormicev.com