Is there a way i can know the rows that where synchronised in the
publisher after some updates are done on subcriber and synchronised
to publishers?
Example say i update a table1 in subcriber and click synchronise and
the data is updated in publisher.
But on publisher side i need to know what rows were added either
through trigger,jobs or columns in system merge tables
Not sure if this helps...but with Merge Replication, there are triggers
(Insert, Update and Delete) set up for tables that particpate in the
replication. Perhaps you could hook into these existing triggers some way?
"vk" wrote:
> Is there a way i can know the rows that where synchronised in the
> publisher after some updates are done on subcriber and synchronised
> to publishers?
> Example say i update a table1 in subcriber and click synchronise and
> the data is updated in publisher.
> But on publisher side i need to know what rows were added either
> through trigger,jobs or columns in system merge tables
>
2012年3月11日星期日
Any store dprocedure to know this in merge replictaion
标签:
database,
dprocedure,
merge,
microsoft,
mysql,
oracle,
replictaion,
rows,
server,
sql,
store,
subcriber,
synchronised,
synchronisedto,
thepublisher,
updates
订阅:
博文评论 (Atom)
没有评论:
发表评论