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.
–Frank
http://www.insidesql.de

---

True, take help of PROFILER with the actions defined by Frank.
See thishttp://www.databasejournal.com/features/mssql/article.php/10894_3307541_2 is any help. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>