Identity columns

212,941pages on
this wiki
Add New Page
Add New Page Discuss this page0

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