Hi,
I have 2 different subscribers for the replicated database. What I want is
that do is to provide subscribers access to different tables i.e. if Table
"A" is on Subscriber1 machine I want Table "B" on Subscriber 2 and replicate
them with publisher. Is it possible?
Thanks
@.source_table and @.destination_table are properties of sp_addarticle
rather than sp_addsubscription so this isn't possible in one publication.
Why not consider 2 publications? Alternatively you could use different views
which relate to the same replicated table on each subscriber.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment