To create a replication definition for a table that contains an identity column, specify “identity” as the declared datatype for the column or use a column-level translation to specify “identity” as the published datatype for the column.
A replication definition, or multiple replication definitions for the same table, may not publish more than one column that has the datatype identity.
Note that if one replication definition publishes a column as “identity,” another replication definition may publish the column as numeric and avoid having the extra commands sent with an insert for subscribers to the second replication definition.
