Indices and Schema applied during snapshot when drop table not che -- sql server replication

Larry Herbinaux
8/9/2006 1:54:51 PM

During the create publication process, I selected the "Delete all data in the
existing table" option in the Name conflicts section. I do not want the
existing table dropped and re-created.

I would expect only bulk copy statements in the agent log, but I also see

Hilary Cotter
8/9/2006 10:52:25 PM

This is probably the primary key in .idx. These files are generate in case
the table does not exist on the subscriber.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Larry Herbinaux" <LarryHerbinaux@discussions.microsoft.com> wrote in
message news:EB315074-AA0E-4848-90D8-A84D409B9CC9@microsoft.com...
[quoted text, click to view]

sql server replication : Indices and Schema applied during snapshot when drop table not che