Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TSharp
Starting Member
9 Posts |
 Posted - 2008-07-08 : 16:47:48
|
| Assume the following scenario. 1. A single SQL Server publishes and distributes two merge publications, A and B.2. Publication A includes x articles, among which is Table1, Table2, and Table3.3. Publication B includes y articles, also including Table1, Table2, and Table3.4. There is one subscriber to publication A and one separate subscriber to publication B.5. All SQL Servers are SQL Server 2000. Here is my question: Will changes made in Table1, Table2, and Table3 on either the publisher or subscriber in publication A be correctly propagated to the subscriber in publication B, and vice versa (i.e., will changes made in Table1, Table2, and Table3 on either the publisher or subscriber in publication B be correctly propagated to the subscriber in publication A)? Thanks in advance for your assistance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-08 : 17:01:56
|
| NO. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-08 : 23:00:05
|
| Are those tables used in publication a and b in same db? If so, will have problem. |
|
|
|
|
|
|
|
|
Overlapping merge publications