We created a recursive store procedure. When the recursivity generates more than 15 calls we get:
CALL Failed  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!
There's no way to increase this limit, it's built-in.
But usually recursion can be rewritten with loops :-)