Replicating to SSCE tables with "create statistics" doesn't works: how to avoid

When merge replicating SQL Server tables with created Statistics, the SSCE
subscription to that table fails. To avoid this problem I manually deleted
the lines with CREATE STATISTICS statements from the *.dri archives that
contains the script for index creation on the snapshot. The *.dri archives
are generated by the Snapshot Agent and uploaded into the IIS that acts as a
replication gateway between SS and SSCE.
My concerns are how safe is doing this?
It's highly recommended in SS to enable statistics for tables. Our database
without them turns to be too slowly. On the other hand when enabling
statistics we can't synchronize with SSCE users. Then this incompatibility
with SSCE when replicating is highly restrictive for the usability of SSCE.
Why it isn't an "official" solution to this problem, when the solution looks
to be so simple? Or may be it is not so simple...
Any comments will be highly appreciated
Thanks in advance
Faustino Dina
If my email address starts with two 'f'
drop the first 'f' when mailing me.
Faustino,
you could use sp_addscriptexec with the SkipError bit set to 1.
This will enable you to apply the create statistics command to all
subscribers regardless of the edition they have.
HTH,
Paul Ibison