Best approach to change from identity(1,1) to identity(1,5)

Posted by Ice on Server Fault See other posts from Server Fault or by Ice
Published on 2010-04-23T06:00:45Z Indexed on 2010/04/25 15:54 UTC
Read the original article Hit count: 446

Filed under:

i have some big tables with several million records and want to change the identity(1,1) to identity(1,5). what would be the best way to do that?

© Server Fault or respective owner

Related posts about sql-server-2008