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.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  can a publisher be also a subscriber in other db?

Author  Topic  mattyau Starting Member 3 Posts Posted - 2001-09-16 : 11:32:48 Hi, I have 3 database, A, B and C. On every half year, I have to schedule replication from B to C, and then from B to A. Should I use snapshot publication? I have tried to use 2 publication, one from B to C, and one from A to B. When replicating from B to C, it is successful. But when replicating from A to B, it failed with message "Cannot drop the table 'table1' because it is published for replication." Is this message occur because I set database B as publisher and subscriber? If yes, is there any suggestions to solve this problem? Thanks, Matt