Is a stored procedure not closing a database connection?
This is a scrbe insight package that does some seeks and then runs a stored procedure against a sql database. Records that are meant to fail in the SP process ok (with status failed) but other records that are meant to run are skipped. Is it not closing the SP connection ? The error below is on the seek steps.
Error Number: 0x000003ed (1005)
Native Error: 0x00000000 (0)
Source: [Microsoft][ODBC SQL Server Driver]
Description: [HY000] SQL call failed. Connection is busy with results for another hstmt