sqlsvr wrote:

> Running a COUNT query on a table basically made Firebird unresponsive and is holding up all other queries to that table (and Firebird itself).
>
> Is there a way of stopping a long-running query WITHOUT bringing the whole DBMS down?

Just delete the appropriate record from MON$STATEMENTS and it should stop.

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================