change identity increment value | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

change identity increment value

How do I keep existing identity column, change the seed value and increment value.
I know I can use DBCC checkident to reseed, but how to change increment value?
I don’t think there is a single t-sql statement for this. When you look behind the scenes what EM does in such a case, you’ll see that a table with the new increment value is created and than the rows are moved into that new table which finally is renamed. Looks like the way to go for you.

True, take help of PROFILER with the actions defined by Frank.
See this is any help. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.