Fandom

Scratchpad

Identity columns

216,181pages on
this wiki
Add New Page
Discuss this page0 Share

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.

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).

Also on Fandom

Random wikia