SQL Server Performance Forum – Threads Archive
change identity increment valueHow 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 thishttp://www.databasejournal.com/features/mssql/article.php/10894_3307541_2 is any help. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.