Column Invalid for Replication Timestamp
When attempting to set CHECK CONFLICTS for an element in a CREATE REPLICATION statement, you may encounter an error similar to the following.
8004: Column REPL.TABS.TS cannot be used for replication timestamp checking if in an index or added by ALTER TABLE; and must be binary(8) with NULL values allowed.
In this situation, check:
-
That the timestamp column in the specified table is a nullable column of type
BINARY(8). In the above example, the TS column in theREPL.TABtable should have a type ofBINARY(8). -
The timestamp column is defined in the original
CREATE TABLEstatement, rather than added later usingALTER TABLE.