QA hangs when closing MDI child | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

QA hangs when closing MDI child

SQL 2000 Client tools <br /><br />Quite often when I have several query windows open in Query Analyser, when I close one of them using CTRL F4, the whole application locks up. I have to kill the task and lose any unsaved query windows. Very annoying as Im sure you can imagine <img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ /><br /><br />Does anyone else get this?<br /><br />Does anyone know what causes it/how to fix?<br /><br />Thanks<br /><br />
You may see different SPID for each query but behind the scene, they are pooled connection. Where you trying to "close" a running query? If not, what’s your SP? May the Almighty God bless us all!
www.empoweredinformation.com
Sorry, maybe I explained badly. There are no queries running when I try to close one of the query windows.
Lets say I have 3 queries open, but not running. I close one of the query windows within query analyser, and the application hangs.

Hi Chappy,
Check this KB which details about similar problem.
http://www.kbalertz.com/Feedback.aspx?kbNumber=291235
But resolution is as always: install latest service pack
I was about to ask about service pack level, but I think that may or may not fix the issue.
This will happen due to the client tools issue and resources usage on the desktop, it will best to perform on another machine with similar settings. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>