kill bad query

2001-03-07 Thread Steve Ruby
If I have a connection that executes a bad query shouldn't I ALWAYS be able to kill it with "kill connect num"? I have a query that keeps getting stuck, (who knows what it is doing) but that State is "statistics" I can't ever kill it without taking down the server..

Re: kill bad query

2001-03-07 Thread Steve Ruby
Steve Ruby wrote: If I have a connection that executes a bad query shouldn't I ALWAYS be able to kill it with "kill connect num"? I have a query that keeps getting stuck, (who knows what it is doing) but that State is "statistics" I can't ever kill it without taking down the server..

RE: kill bad query

2001-03-07 Thread Quentin Bennett
PROTECTED] Subject: Re: kill bad query Steve Ruby wrote: If I have a connection that executes a bad query shouldn't I ALWAYS be able to kill it with "kill connect num"? I have a query that keeps getting stuck, (who knows what it is doing) but that State is "statistics"