Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    4

    Unanswered: Change Increment Value for existing Identity Column

    Hi,
    How to Change Increment Value for existing Identity Column (MS SQL2000) ?

    I know how to change the seed :
    DBCC CHECKIDENT (activity, RESEED,4233596)

    but I need the future id generated with step 2
    4233596
    4233598
    4233600
    I would like to do it using T-sql because I will need to do it every day after syncronising with another SQL server .

    Thanks,
    Natalia

  2. #2
    Join Date
    Sep 2003
    Posts
    364
    You have to drop and recreate the table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •