Home All Groups Group Topic Archive Search About

Query Analyzer Locking Up

Author
22 Mar 2006 9:18 PM
Preacher Man
I just installed client tools and when I use the QA it will hook up to the
Database just fine, but if I go to the file menu, it locks up.  Any ideas?

Author
22 Mar 2006 9:50 PM
Jasper Smith
Have you applied SQL SP4 to your client install? It contains some fixes for
QA lockups.
http://www.microsoft.com/downloads/details.aspx?FamilyID=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en

The file you want is SQL2000-KB884525-SP4-x86-ENU.EXE

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com


Show quote
"Preacher Man" <nospam> wrote in message
news:O2qzvZfTGHA.4520@TK2MSFTNGP10.phx.gbl...
>I just installed client tools and when I use the QA it will hook up to the
>Database just fine, but if I go to the file menu, it locks up.  Any ideas?
>
Author
22 Mar 2006 11:04 PM
Preacher Man
I have installed SP4 and it still locks up.  It's wierd.  I can go to the
edit and tools menu, but as soon as I hit the file menu, it locks up.  To
add to the mystery, I can log in as someone else on the same PC and it works
fine.  Go figure?

Thanks.


Show quote
"Jasper Smith" <jasper_smi***@hotmail.com> wrote in message
news:OuE4xqfTGHA.4900@TK2MSFTNGP12.phx.gbl...
> Have you applied SQL SP4 to your client install? It contains some fixes
> for QA lockups.
> http://www.microsoft.com/downloads/details.aspx?FamilyID=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
>
> The file you want is SQL2000-KB884525-SP4-x86-ENU.EXE
>
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
>
> "Preacher Man" <nospam> wrote in message
> news:O2qzvZfTGHA.4520@TK2MSFTNGP10.phx.gbl...
>>I just installed client tools and when I use the QA it will hook up to the
>>Database just fine, but if I go to the file menu, it locks up.  Any ideas?
>>
>
>
Author
22 Mar 2006 11:53 PM
Jasper Smith
Did it ever work? Since it sounds profile related have a look at
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQL Query
Analyzer\Recent File List in regedit. Are there any entries and if so are
they possibly pointing to invalid network locations i.e. a mapped drive that
no longer exists? If there are any entries apart from the (Default) value
then it might be worth exporting them and then deleting them and seeing if
that helps.

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com


Show quote
"Preacher Man" <nospam> wrote in message
news:%23X71IVgTGHA.5468@TK2MSFTNGP14.phx.gbl...
>I have installed SP4 and it still locks up.  It's wierd.  I can go to the
>edit and tools menu, but as soon as I hit the file menu, it locks up.  To
>add to the mystery, I can log in as someone else on the same PC and it
>works fine.  Go figure?
>
> Thanks.
>
>
> "Jasper Smith" <jasper_smi***@hotmail.com> wrote in message
> news:OuE4xqfTGHA.4900@TK2MSFTNGP12.phx.gbl...
>> Have you applied SQL SP4 to your client install? It contains some fixes
>> for QA lockups.
>> http://www.microsoft.com/downloads/details.aspx?FamilyID=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
>>
>> The file you want is SQL2000-KB884525-SP4-x86-ENU.EXE
>>
>> --
>> HTH,
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>>
>>
>> "Preacher Man" <nospam> wrote in message
>> news:O2qzvZfTGHA.4520@TK2MSFTNGP10.phx.gbl...
>>>I just installed client tools and when I use the QA it will hook up to
>>>the Database just fine, but if I go to the file menu, it locks up.  Any
>>>ideas?
>>>
>>
>>
>
>

AddThis Social Bookmark Button