Following statement can reset seed
DBCC CHECKIDENT ('TableName', RESEED, 1)
but this time I have to change its increment .
+3
A:
Hope this helps
ALTER TABLE MyCustomers
ALTER COLUMN CustId IDENTITY (200, 2)
Code from ms-help://MS.VSCC.v90/MS.MSDNQTR.v90.en/ssmprog3/html/5719d3e4-14db-4073-bed7-d08f39416a39.htm
petergo
2009-05-07 08:11:26
+1 Editted for clarity
Dead account
2009-05-07 08:14:08
this is a 'documentation' bug. suggested syntax will fail. you cannot ALTER the increment value for an identity. you must drop/re-create the column or table
Nick Kavadias
2010-04-23 04:29:38
A:
Aleris
2009-05-07 08:26:18
A:
The following SQL statement does not work
ALTER TABLE MyCustomers ALTER COLUMN CustId IDENTITY (200, 2)
Can you give correct syntax ?
kavitha
2009-10-23 14:28:28
A:
Was the T-SQL for this determined? The SQL statement originally posted by petergo and edited by Ian Quigley doesn't work for me, either. I get "Incorrect syntax near the keyword 'IDENTITY'." and adding the column data type to the alter statement doesn't help.
Karen Wallace
2010-02-04 20:00:06