Re: Query Analyzer Locks Up When Saving a file

From: Steve Kass (skass_at_drew.edu)
Date: 01/05/05


Date: Tue, 04 Jan 2005 19:05:47 -0500

There are good reasons for not making all hotfixes available
publicly, but if you don't want to make the call, you have some
options:

1. There's a chance it could be this issue:
http://groups.google.co.uk/groups?q=kass+query+analyzer+nvidia&hl=en
2. Try a publicly available hotfix and hope this is part of it:
  (http://support.microsoft.com/?kbid=821334 or
http://support.microsoft.com/?kbid=838166)
3. Take a risk and install the beta version of SQL Server 2000 Service
Pack 4 (it'll take about a day for the beta enrollment to go through).
I don't recommend this for a production server, but if it's a
development machine, or better yet, just a machine with the SQL Server
tools on it, there's less risk.
  (http://support.microsoft.com/default.aspx?scid=kb;en-us;290211)

If this is for a production server, the call to PSS is definitely the
safest route.

Steve Kass
Drew University

dw wrote:

>Query Analyzer keeps locking up when saving a file, it says there is a fix
>available for it ( http://support.microsoft.com/?kbid=830767 ) but we have to
>open a trouble call to get the fix?? Is this fix available anywhere without
>having to pay for it? This is very frustrating when it happens, especially if
>you haven't saved your query yet.
>
>



Relevant Pages

  • Re: SQLVDI Error
    ... One reason I steer clear of hotfixes (well ones that are not critically ... I see that MS is indicating it is best to wait until the fix comes ... Device Interface in SQL Server 2005 or in SQL Server 2000 ... Les Connor [SBS MVP] ...
    (microsoft.public.windows.server.sbs)
  • Re: Hotfix Post SP4
    ... Build 2148, to fix the SQLDiag issue, but also fixes another 10 or so. ... to fix the Query Analyzer DTC issue. ... SQL Server Version Database ... You receive an error message if you use the sp_addalias or sp_dropalias ...
    (microsoft.public.sqlserver.clustering)
  • Re: A2007 convert ADP forms to MDB forms?
    ... We had applied various hotfixes after the first tests, ... The 2500 queries that are launched are after doing a single-column update ... development, later SQL Server Express for development, SQL Server 2005 on ... removed record source property and tried a,b,c above - no go ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Inconsistent negative numerical values in SQL2K database table
    ... Earl Newcomer wrote: ... >fix of 1*value and it works as you mentioned. ... As far as I can tell, so long as SQL Server has to do an arithmetic ... Since the cube is partitioned some of the partitions are ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2000 SP4 - realease date
    ... it looks like SP4 is targeted for the first half ... there is no "fix" with UMS non-yielding processes ... New concurrency and scheduling diagnostics added to SQL Server: ... FIX: You are prompted for password confirmation after you change a standard ...
    (microsoft.public.sqlserver.server)