Help needed in 2-way replication

I am using transactional replication across 2 servers and I am trying to configure one server to replicate to the other one and vice versa. My aim is to create a platform where 2 different databases can be written to and both servers will hold identical data.

My problem is that when an update occurs it seems to become stuck in a loop where the value goes back and forth from the new value to the old one, obviously replicating the value from the secondary database before updating the secondary databse with the new value. Is there anyway of stopping this?

My platform requires instant replication from both servers which was why I have opted for transactional but I question if this is the best choice if I am trying to perform 2-way replication. Any advise on this matter.

Thank you for any help offered.

I have found the solution to my problem. To execute bidirectional replication with SQL Server 2000 do not use the wizard to create a subscription but instead make use of two stored procedures sp_addsubscriber and sp_addsubscription. Ensure that @loop_detection is enabled.

You posted to the wrong forum, there is an MsSQL forum specific for SQLServer.