sp_setreptable now includes a use_index parameter.
sp_setreptable <table_name> [, true | false] [, owner_on | owner_off | null] [, use_index]
use_index – Adaptive Server creates a global nonclustered index on the text or image pointer for all existing tables with text or image data that are not explicitly marked for replication.
Creates table t1, marks the table for replication, and creates two indexes on the text and image pointer for the columns t and i.
create table t1 (c int, t text, i image) go sp_setreptable t1, true, null, use_index go
Marks the table for replication without using indexes:
sp_setreptable t1, true
