How Replication Server Replicates identity Columns

Replication Server applies two commands to control replication of identity columns.

Replication Server applies the following command to the replicate table before insert:

set identity_insert table_name on

Replication Server applies the following command to the replicate table after insert:

set identity_insert table_name off

If a column you are adding to a replication definition contains an identity column, the maintenance user must either be the owner of the table, or must be “dbo” or aliased to “dbo”, or must have sa_role pemission at the replicate database in order to use the Transact-SQL identity_insert option to perform operations on the table.Without the proper permissions, you see an error message in the Replication Server log as replication of identity columns cannot proceed.