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, Procdure UserUpdatePlanning, Ligne 10
Le niveau maximal d'imbrication des procdures stockes, des fonctions, des
dclencheurs ou des vues est dpass (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,
Paul Ibison
Monday, March 26, 2012
pb replication with sql express 2005
Labels:
database,
express,
microsoft,
mysql,
oracle,
replication,
running,
server,
sp4,
sql,
sqlexpress,
subscriber,
transactionnal
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment