Step 2. Check for an IDENTITY Column

Every source table must contain an IDENTITY column, which uniquely identifies each row and provides a means of joining the index table and the source table.

For example, to add an IDENTITY column to the reviews table, enter:

alter table reviews add id numeric(10,0) identity

See “Adding an IDENTITY Column to a Source Table” for more information on creating an IDENTITY column.