in reply to Re: MS SQL Stored Procedure Syntax
in thread MS SQL Stored Procedure Syntax

DBI should clean things up for you when you read the end of the result set, but the fix is probably to call finish() manually.
$sth->finish(); $rc = $dbh->disconnect();
It's just a warning that the statement handle is still marked as active. That could mean you have more results to read, or that the server's allocated some resource and hasn't give it back yet. You could disable warnings, but it's probably better just to call finish.

©