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
Showing posts with label 2000pull. Show all posts
Showing posts with label 2000pull. Show all posts
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:
Posts (Atom)