Replication Limit Exceed Error

• DBABC

  SSCarpal Tunnel

  Points: 4813

  More actions

  July 24, 2008 at 12:18 pm

  #190200

  HI,

  I have a db on SS2k5 SE. I replicated its one table that has an update trigger also. But i have replicated the table only, i didnt publish the trigger. I am using Trasactional Publication with Updateable Subscription.

  Now when i try to update a row in publisher it is giving me following error

  "Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)."

  Following operations are working fine.

  Insertion on publisher/subscriber

  Deletion on publisher/subscriber

  updation on subscriber.

  any idea?

  Thanks,

  Usman

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  July 24, 2008 at 3:51 pm

  #848129

  Check out these posts -

  http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2277232&SiteID=1

  http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=45101&enterthread=y

  Pretty sure your problem is similar to what is being described here.

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot