problem when applying a snapshot when tables have been updated during snapshot generation

hi

   seem have strange problem when applying snapshot when tables in publication have been updated while snapshot being generated.

 

  example there table called rmareplaceditem in publication. when snapshot starts being applied subscriber, stored procedure called sp_msins_rmareplaceditem_msrepl_css gets created handles insert if row exists (ie updates row rather inserting it). however, after data has been loaded tables, instead of calling procedure, tries call 1 called sp_msins_rmareplacedite_msrepl_cssm - takes last letter of table name , adds end of procedure name.

 

   worst part causes application of snapshot fail, doesnt report error is, , instead tries applying snapshot again. way have managed find call failing run profiler against subscriber while snapshot being applied , see errors.

 

   have run sp_broswereplcmds , data in there applied subscriber - ie wrong procedure name.

 

   servers involved running sql 2005 service pack 2. publisher , subscriber both upgraded sql 2000, distribution server fresh install of sql 2005.

i've had similar issue , seems happen when there lot of activity on subscriber. reason insterting data subscriber , lot of selects going on blocking index creation.

 

what did table set create on pk , clustered index. non-clustered indexes run job manually create them after snapshot complete

SQL Server  >  SQL Server Replication