Post reply

reset the identity value

  • March 28, 2002 at 12:50 pm

    #104888

    How can I reset the identity value without needing to rebuild the table? What I wanna do is to reset to one when the identity value reach an used defined value.

    Cheers

    Dev


    Cheers

    Dev

  • March 28, 2002 at 12:54 pm

    #426254

    This will reset it to 1:

    DBCC CHECKIDENT (tablename, reseed, 1)

    Steve Armistead,

    Database Administration

    Panther Systems Northwest, Inc.

    Vancouver, WA

    Steve

  • March 28, 2002 at 1:05 pm

    #426257

    thanks for your help, it works great.

    Cheers

    Dev


    Cheers

    Dev

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

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