Post reply

Maximum databases exceeded

  • January 29, 2004 at 5:07 pm

    #101864

    Hello,

    I just added an update statement to another table from an update trigger in the table I am updating a record on. The update is to a table in another database. When the update is executed I get the following error:

    Maximum number of databases used for each query has been exceeded. The maximum allowed is 8.

    What causes this error and can this maximum be changed?

    Thanks,

    Dan

  • January 30, 2004 at 10:50 am

    #492378

    I'm guessing that there can only be 8 databases in a particular transaction. I don't see anything in BOL relating to this. Does the update cross 8 dbs?

  • January 30, 2004 at 11:15 am

    #492381

    Steve,

    No, I am in database1 running an update on table1 - The update trigger fires, and should be doing an update to database2.dbo.table1 with inserted values. That's it... Doing the same thing from database2 to database1 works just fine...

    Dan

  • January 30, 2004 at 1:19 pm

    #492399

    Found the problem... I should have realized it earlier... both databases were going into an endless update to each other, once I initialized the update from database1, the trigger in database2 would send that update right back to database1, then database1 would try to send it back to database2 and on and on...

    Dan

  • January 30, 2004 at 4:23 pm

    #492417

    Doh! , done that myself. Thanks for the update.

  • September 5, 2005 at 4:14 am

    #587540

    Hi guys,

    I'm encountering the same problems and already figured out that it has something to do with one or several of the triggers I'm using, but I do not exactly understand what the problem is. The highest nestlevel I can find is 3.

    Does a trigger, which is responding to an update, everytime add a new database connection, even while the connection is already open?

    Thanks in advance for the answer

    Antonie

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply