Merge replication on SQL Server 2000 sp3 and Win 2000
Pull subscription with MSDE.
The subscribers need info on replication status.
I query MSmerge_history and MSmerge_agents with a join on agent ID.
I would like to filter by subscriber_name, but this field is empty for each
subscriber.
I've tried to drop a pull subsriptions many times. But this field stays
empty.
The field subscriber_id has a correct value and everything with replication
looks OK.
I think this should be the only one table with both fields subscriber_id and
subscriber_name together. So maybe the only way to know the ID of the
subscriber with his name.
1. Do I have another way to know pair subscriber_id <-> subscriber_name. So
I don't filter with subscriber_name, but with subscriber_id.
2. Can I without risk to update manually MSmerge_agents table after pull
subscription to fill correctly subscriber_name.
3. I've made something wrong during merge replication installation?
4. Bug (I can correct) ...
Thanks for help
Olivier
May be I was not so clear... Shorter version:
Is it normal to have null value in field subscriber_name
(distribution-MS_merge_agents) ?
Can I manually enter the correct value? I'm not used to do changes in system
tables without help of SP.
Thanks for help
Olivier
sql
Wednesday, March 21, 2012
MSmerge_agents table
Labels:
2000pull,
database,
merge,
microsoft,
msde,
msmerge_agents,
mysql,
oracle,
query,
replication,
server,
sp3,
sql,
status,
subscribers,
subscription,
table,
win
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment