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:
- in database where record list located, i setup new transactional replication, set emanate snapshot.
- once announcement created, i emanate new pull subscription, set initialize immediately.
- 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
Post a Comment