Fandom

Scratchpad

Identity columns

221,916pages on
this wiki
Add New Page
Discuss this page0 Share

Replication Issues

  • Datatype in replication definition must be ’identity’ for the identity column.
  • The maintenance user (dbmaint01) must be aliased as dbo in the replicate database.

BCP Issues

  • Must use the –E option of BCP in order to maintain value of the identity column.

ASE Configuration and Table Creation

  • Configuration parameter identity burning set factor is set to the non-default value of 1, and all identity columns in the database should have a precision of numeric(10,0). This allows 1001 identity values to be discarded in the event of server failure (or shutdown with nowait).

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.