records replicated extrinsic tradition riposte stored procedure


i've only recently setup tradition riposte subscriber database, described . basically, publisher pushes new record subscribers, stored way also insert replicated an additional buttress table, insert new record record table.



my problem occurs perplexing replicate record list behind sure announcement database. i did:




  1. in database where record list located, i setup new transactional replication, set emanate snapshot.

  2. once announcement created, i emanate new pull subscription, set initialize immediately.

  3. once subscription created, i checked synchronization station endorse image receptive successfully.



now here's uncanny part: i manually supplement record record list controlling sql server supervision studio, record replicated fine. record total tradition riposte stored procedure, not. station always arrangement "no replicated sell available".



i have thought since announcement operative way: i unequivocally don't treating information extrinsic tradition riposte stored way differently.



can someone explain competence i've finished wrong?



update: i finally have an answer problem few months ago, only i never got around transform question. have record support microsoft, nonetheless got operative solution.





answer: solve problem, adding subscription,
you need run book below:



sp_addsubscription @publication = 'test', ..., @loopback_detection = 'false'


the pivotal fortitude final parameter shown above. default, generated subscription book have parameter.



Comments

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?