SQL Analyzer hang ?

External Since: Oct 13, 2004 Posts: 1

Steve, One vote from me too Smile

Arun

"Aneesh Aravind" wrote:

> I elect Steve to the post of MVP!! This is cool. I turned off my NVidia's
> nView Desktop Manager, and QA stopped crashing!! If anyone at Microsoft is
> reading this, I suggest you investigate what nView has to do with QA.
>
> Mr. Kass, thank you for your help.
>
> Aneesh Aravind
> Campanella, Inc.
> 3710 Rawlins St., Suite 1215
> Dallas, TX 75219
> Office: 214.522.4122 x229
> Fax: 214.522.5151
> aaravind_at_campanella_dot_net
>
> "Steve Kass" wrote:
>
  > > If you're using nVidia's nView Desktop Manager, disable it and see if
  > > that helps. It could be
  > > other video driver issues. There is a known bug that can cause QA to
  > > hang, but your symptoms
  > > seem different (http://support.microsoft.com/default.aspx?kbid=830767).
  > > Is isqlw.exe getting
  > > 100% of the CPU while this happens?
  > >
  > > Steve Kass
  > > Drew University
  > >
  > > Thomas McFarlane wrote:
  > >
   > > >I have a mysterious hang that I cannot figure out: I am running Win XP Pro
   > > >Sp2 on a new Dell OptiPlex GX280 with 1GB RAM. 3.9GHZ CPU. My MS/SQL 2000
   > > >Client version is:
   > > >
   > > >Microsoft SQL Server 2000 - 8.00.859 (Intel X86)
   > > > Sep 18 2003 12:53:45
   > > > Copyright (c) 1988-2003 Microsoft Corporation
   > > > Standard Edition on Windows NT 5.2 (Build 3790: )
   > > >
   > > >
   > > >The SQL Client is a Developer version came with Visual Studio.Net 2003.
   > > >
   > > >The hang is described below:
   > > >
   > > >1. When SQL Analyzer came up, it logged in to my Windows 2003 Standard
   > > >SQL/2000 Server via Integrated Windows all right.
   > > >2. It lets me select a database to work with. I can write SQL script and
   > > >execute it OK.
   > > >3. It lets me open a sql script file from my local disk drive. However, as
   > > >soon as I click on the work area, the SQL Hour glass is fired up and sits
   > > >there until my task manager say Sql Query Analyzer not responding. I have to
   > > >kill it.
   > > >
   > > >Thanks for your help,
   > > >
   > > >Tom
   > > >
   > > >
   > > >
   > > >
  > >

External Since: Aug 28, 2003 Posts: 153

I'm glad to have helped!

SK

Arun wrote:

>Steve, One vote from me too Smile

>Arun
>
>"Aneesh Aravind" wrote:
>
>
>
  >>I elect Steve to the post of MVP!! This is cool. I turned off my NVidia's
  >>nView Desktop Manager, and QA stopped crashing!! If anyone at Microsoft is
  >>reading this, I suggest you investigate what nView has to do with QA.
  >>
  >>Mr. Kass, thank you for your help.
  >>
  >>Aneesh Aravind
  >>Campanella, Inc.
  >>3710 Rawlins St., Suite 1215
  >>Dallas, TX 75219
  >>Office: 214.522.4122 x229
  >>Fax: 214.522.5151
  >>aaravind_at_campanella_dot_net
  >>
  >>"Steve Kass" wrote:
  >>
  >>
  >>
   >>>If you're using nVidia's nView Desktop Manager, disable it and see if
   >>>that helps. It could be
   >>>other video driver issues. There is a known bug that can cause QA to
   >>>hang, but your symptoms
   >>>seem different (http://support.microsoft.com/default.aspx?kbid=830767).
   >>>Is isqlw.exe getting
   >>>100% of the CPU while this happens?
   >>>
   >>>Steve Kass
   >>>Drew University
   >>>
   >>>Thomas McFarlane wrote:
   >>>
   >>>
   >>>
   >>>>I have a mysterious hang that I cannot figure out: I am running Win XP Pro
   >>>>Sp2 on a new Dell OptiPlex GX280 with 1GB RAM. 3.9GHZ CPU. My MS/SQL 2000
   >>>>Client version is:
   >>>>
   >>>>Microsoft SQL Server 2000 - 8.00.859 (Intel X86)
   >>>>Sep 18 2003 12:53:45
   >>>>Copyright (c) 1988-2003 Microsoft Corporation
   >>>>Standard Edition on Windows NT 5.2 (Build 3790: )
   >>>>
   >>>>
   >>>>The SQL Client is a Developer version came with Visual Studio.Net 2003.
   >>>>
   >>>>The hang is described below:
   >>>>
   >>>>1. When SQL Analyzer came up, it logged in to my Windows 2003 Standard
   >>>>SQL/2000 Server via Integrated Windows all right.
   >>>>2. It lets me select a database to work with. I can write SQL script and
   >>>>execute it OK.
   >>>>3. It lets me open a sql script file from my local disk drive. However, as
   >>>>soon as I click on the work area, the SQL Hour glass is fired up and sits
   >>>>there until my task manager say Sql Query Analyzer not responding. I have to
   >>>>kill it.
   >>>>
   >>>>Thanks for your help,
   >>>>
   >>>>Tom
   >>>>
   >>>>
   >>>>
   >>>>
   >>>>
   >>>>