sql server - Why would you put Identity Increment other than 1 in SQL? -

in sql server, can set increment of identity column other 1.

in situation that?

this might valid reason it, though i'm not sure.

we had application spread out across 2 environments, 1 web server, 1 db server per environment.

both environments "active" @ same time , have tables written too.

environment "a" had identity of (1,2), , environment "b" had identity of (2,2) - both , b have records written without risk of overlapping identities when data merged together, there no need rejigger ids.

there other ways behavior without doing above, quick , easy.