When IDENTITY columns are transferred to the Subscriber, the IDENTITY property will not be transferred. (For example, a column defined as INT IDENTITY at the Publisher will be defined as INT at the Subscriber.)
If you want the IDENTITY property transferred to the subscription table, you must do the following:
» Create the subscription table manually using the IDENTITY property and the NOT FOR REPLICATION option.
» Set the name conflict article property so that SQL Server does not drop an existing destination table when applying the snapshot. This property is found on the Snapshot tab of article properties.
The following published tables contain IDENTITY columns:
When both row and columns groups based on a recursive hierarchy exist, the Level function requires a scope. Specify a scope ...
When calling stored procedure sys].sp_cdc_help_change_data capture, if either @source_schema or @source_name is non-null ...
When executing sp_adddistributor for a remote Distributor, you must use a password. The password specified for the @password ...
When false, security-sensitive information, such as the password, is not returned as part of the connection if the connection ...
When IDENTITY columns are transferred to the Subscriber, the IDENTITY property will not be transferred. (For example, a column ...
When linking to a parameterized report, you can override the defaults by specifying the parameter names and values here. ...
When multiple hierarchies or virtual dimensions are migrated into the same Yukon dimension, the crossjoin of sets including ...
When operating in VertiPaq mode, a measure group can only have degenerate or reference dimension. Measure group '%{name/}' ...
When operating in VertiPaq mode, a table can only be referenced in one measure group. '%{IWTableName/}' table is referenced ...