Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    Montreal
    Posts
    38

    Question Unanswered: How to choose next value for identity column

    Hi,

    I have a table with its ID field set as an Identity column with "seed" and "increment" set to 1. Now, I have rows in there that I don't want to change. I'd like the next addtitions to the table to start at a specific value for their ID columns.

    Basically, how can I specify a new starting value for an identity column?

    Thanks,

    Skip.

  2. #2
    Join Date
    Oct 2003
    Posts
    10

    this might help...

    I found this in SQL Server books online as well as the web. This sounds like what you might be looking for.

    http://msdn.microsoft.com/library/de..._dbcc_5lv8.asp

Posting Permissions

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