I had a stored procedure which raises connection to a webservice and load the results back into the table. The input BODY for the http request is in a column IP_BODY. I use another stored procedure which loops the webservice stored procedure for all the values in the table.
I'm noticing that after 248 messages processed, my SQL server was not able to raise a HTTP connection with the webservice. Any such limits exists which restricts the number of messages being processed ?