sql server replication: Hi,

I have a main database server running sql server 2000 with sp4.
I have a a subscriber running sqlexpress 2005 server.
I use transactionnal replication with updates autorise on the subscriber.

My configuration seems correct as i can modify my tables content with INSERT
command and found the information replicated in both server.
But each time i try to modify my data using Update commands

update planning set planning_previ_valide = 1 where id_plan = 3656

an error message is displayed
(this is the french version of the error message saying that i have overtake
the limit of 32 triggers, stored procedures, functions ...)

Msg 217, Niveau 16, État 1, Procédure UserUpdatePlanning, Ligne 10
Le niveau maximal d'imbrication des procédures stockées, des fonctions, des
déclencheurs ou des vues est dépassé (limite 32).

Do you have an idea ?

Regards,

Marc

On the server where you get the error, have a look for update triggers on the
Planning table - it seems there is recursion going on which exceeds the max
permitted looping of 32.
HTH,