Hi all,

I want to create transactional replication between two SQL 7 (SQL A & SQL
B). When I config SQL B , replicaiton raise errors. I config as follows:

1. Set SQL A as a distributor and publisher.
2. Add a subscriber SQL B.
3. Publish articles from SQL A.
4. Push a subscriptions to SQL B and start the snapshot agent to initialize
the SQL B that will copy all data to SQL B and create replication stored
procedure at SQL B.
5. Set SQL B as a distributor and publisher.
6. Add a subscriber SQL A.
7. Publish articles from SQL B.
8. Push a subscriptions to SQL A without strarting the snapshot agent and
choose subscriber already has the schema and data.

After configuration, replication seems to work properly. However, when I
insert, delete, update record in SQL B , replication raise error - stored
procedure can not be found. Then I transfer stored procedure to SQL A by
stopping replication, it raise another error, column name does not match
table structure, after starting replication again.
If I start the snapshot agent to create the stored procedure in step 8, SQL
A does not create procedure and raise error - table can not be drop.

Sorry for a log message!!

My problem is How can I config the second Publisher ??

Thanks in advance!!

Wilson