Bidirectional Replication

Hello everybody:
I'm having trouble with bidirectional replication.
This is the case:
As an introduction i'm implementig a transactional replication and I have 2
Servers called A and B, and i made a tabled called Table 1 with 2 fields
number int key and Name nvarchar(50). I modified the sps of replication
avoiding inserting duplicated keys.
I made a trans pub in A and the same in B, later a subscription from the
each other. When i insert a row, no probl. neither when i modified in a row,
but if a modification ocurrs in the same row with the same key in both
servers, the commands with its respective transaction are inserted.
But the tables MSRepl_commands and MSRepl_Transactions begun to grow in a
desmesurate way until the log of the distribution databse collapse or the
log of database in server A or B.
Then i look in MSRepl_commands and the field command is the same.
How can i resolve this trouble?
I manually modified the following Sps.
dbo.sp_MSadd_repl_command and dbo.sp_MSadd_repl_commandHP and all about
dbo.sp_MSadd_repl_command avoiding insercion of a duplicated command.
Is that right?
I couldnt find any help on internet and i spend several days in this
problem....
HELPPPPPPPPPP!!!!!!!!!!!!!!!!!!!!!!!
You nee to set up the @.loopback_detection to TRUE in sp_addsubscription.
"Eng. Leandro Pérez Guió" wrote:

> Hello everybody:
> I'm having trouble with bidirectional replication.
> This is the case:
> As an introduction i'm implementig a transactional replication and I have 2
> Servers called A and B, and i made a tabled called Table 1 with 2 fields
> number int key and Name nvarchar(50). I modified the sps of replication
> avoiding inserting duplicated keys.
> I made a trans pub in A and the same in B, later a subscription from the
> each other. When i insert a row, no probl. neither when i modified in a row,
> but if a modification ocurrs in the same row with the same key in both
> servers, the commands with its respective transaction are inserted.
> But the tables MSRepl_commands and MSRepl_Transactions begun to grow in a
> desmesurate way until the log of the distribution databse collapse or the
> log of database in server A or B.
> Then i look in MSRepl_commands and the field command is the same.
> How can i resolve this trouble?
> I manually modified the following Sps.
> dbo.sp_MSadd_repl_command and dbo.sp_MSadd_repl_commandHP and all about
> dbo.sp_MSadd_repl_command avoiding insercion of a duplicated command.
> Is that right?
> I couldnt find any help on internet and i spend several days in this
> problem....
> HELPPPPPPPPPP!!!!!!!!!!!!!!!!!!!!!!!
>
>
|||Hello!!!
But what happens if the subscription is a pull subscription?
Best regards...
Leandro
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:4E69CB52-5EA2-4152-A0FF-E77828FBF879@.microsoft.com...[vbcol=seagreen]
> You nee to set up the @.loopback_detection to TRUE in sp_addsubscription.
> "Eng. Leandro Prez Gui" wrote:
have 2[vbcol=seagreen]
row,[vbcol=seagreen]
a[vbcol=seagreen]
the[vbcol=seagreen]