sp_reptostandby now includes a use_index parameter.
sp_reptostandby <db_name> [,'ALL' | 'NONE' | 'L1'] [, '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.
Sets the replication status for pubs2 to ALL and creates a global index on the text and image pointers:
sp_reptostandby pubs2,'ALL', 'use_index'
