Modify TD maximum of 16 open responses per connection

Database

Modify TD maximum of 16 open responses per connection

Hi all,

           We created a recursive store procedure. When the recursivity generates more than 15 calls we get:

CALL Failed [3130] Response limit exceeded.

We find that by default a maximum of 16 open responses per connection is allowed. How can we change this configuration?

PD: We are making store procedure test from SQL Assistance but we will call the store from MS Integration Services package.

Thanks in advance!

Tags (1)
2 REPLIES
Junior Contributor

Re: Modify TD maximum of 16 open responses per connection

There's no way to increase this limit, it's built-in.

But usually recursion can be rewritten with loops :-)

Re: Modify TD maximum of 16 open responses per connection

Thanks a lot for your response!