Thank you for your review.

I can execute the SP 1300 times using a while loop in QA w/o issue.

simple ASP:

function GetDBConnection()

dim tmp

set tmp = server.CreateObject("ADODB.Connection")

tmp.Open GetConnectionString()

set GetDBConnection = tmp

end function

function GetConnectionString()

GetConnectionString = "DSN=database;UID=username;PWD=password;"

end function

dim dbConn

set dbConn = GetDBConnection()

call dbConn.execute("exec mysp")

the "location" is a passed value indicating what id needs to be incremented. I neglected to include that that SP is being called from an ASP. If the...