note tobyink <p>Firstly, how are you connected? FreeTDS or ODBC? If you're connected through FreeTDS, it's pretty difficult to have two queries running concurrently on the same database handle. You need to finish your select before you run any updates. A workaround is to open two database handles on the same database.</p> <p>Secondly, by default MSSQL locks whole pages and often whole tables while one query is running, meaning a situation like yours is likely to cause deadlocks. You could experiment with adding some <a href="http://msdn.microsoft.com/en-gb/library/ms187373.aspx">table hints</a> to your select query; possibly <c>ROWLOCK</c>, perhaps even <c>NOLOCK</c> as a last resort.</p> <div class="pmsig"><div class="pmsig-757127"> <small><small><tt>package Cow { use Moo; has name => (is => 'lazy', default => sub { 'Mooington' }) } say Cow->new->name</tt></small></small> </div></div> 1014976 1014976