Publisher become subcriber to other publication.

Hi,

I just want to know, is it possible to do this ?

If yes, how to do it ?

Thanks.

Yes, it's called republishing and common for merge publications. Please search Books Online for more information.|||

Thanks Greg Y.

Do you have any other reference/manual/step by step example ?

p/s: I'm using SQL server 2000.

|||

See SQL Server 2005 BOL article: Republishing Data

http://msdn2.microsoft.com/en-us/library/ms152553.aspx

|||Please note that if the same articles are involved, the root publisher (top of the replication chain) has to be setup before the republisher is setup.