in reply to Perl Query Locks A MsSQL Database
I'm very surprised your code did not error with something like connection is busy with another statement. Until quite recently to get multiple active statements in MS SQL Server you had to do some rather nasty hacks (see Multiple Active Statements (MAS) and DBD::ODBC).
I'd be interested in what DBD you were using and what library under that.
In Section
Seekers of Perl Wisdom