Replication Server adds timestamp as a Replication Server datatype. timestamp is defined as varbinary(8) with a status bit indicator that differentiates it from varbinary. This allows the replication of timestamp columns to replicate, standby, and MSA databases.
You can also define timestamp as a primary key in a replication definition, and a searchable column in a replication definition and a function replication definition.
The send_timestamp_to_standby configuration parameter is also added to support timestamp replication. When send_timestamp_to_standby is enabled and there are no replication definitions, timestamp columns are sent to the replicate database.
For any table containing timestamp column, the maintenance user must be the owner of the table or must be the “dbo” user of aliased to the “dbo” login name at the replicate database.
