Home Forums SQL Server 2008 SQL Server 2008 - General SQL 2008 Transactional Replication - Pull Subscription for SSRS & Poor Performance RE: SQL 2008 Transactional Replication - Pull Subscription for SSRS & Poor Performance

  • It's easier to script them and apply them after the snapshot has applied.

    If you want them as part of the snapshot to apply automatically you can by changing the article properties.

    Be warned that if an error occurs applying the indexes that the whole snapshot is applied again, so generally better to apply them manually after the initial initialization.