Microsoft Announces SQL Server Hotfixes

Microsoft announced hotfixes for two known bugs. The article "FIX: Cannot Remove Microsoft SQL Server 2000 Desktop Engine After You Upgrade to MSDE 2000 SP2" (available at http://support.microsoft.com/default.aspx?scid=kb;en-us;317619 ) explains that all editions of SQL Server 2000 (Personal, Evaluation, Developer, Standard, and Enterprise) include the 8.00.194.01 build of Microsoft SQL Server Desktop Engine 2000 (MSDE 2000) on the products' CD-ROMs. If you originally used this build of MSDE and you upgrade to MSDE 2000 Service Pack 2 (SP2), you can't remove MSDE 2000 from the computer. This problem occurs only if you upgraded the MSDE release to manufacturing (RTM) build (194.01) directly to SP2. The problem doesn't occur on any other editions of MSDE 2000. The problem also doesn't occur if you first upgrade from the RTM version to MSDE 2000 SP1, then upgrade to MSDE 2000 SP2. You can fix the problem by obtaining SQL Server 2000 SP3, but the article provides a hotfix that was available before the company released the latest SQL Server service pack.

 

The article "FIX: SQL Server 7.0 Scheduler May Periodically Stop Responding During Large Sort Operation" describes a rare condition in which SQL Server gives you the error message "2003-02-10 17:02:54.39 ods The Scheduler 2 appears to be hung. PSS 0x5F8B3110, EC 0x5F8B32C0, UMS Context 0x050D07D8." When SQL Server processes a query that includes a large, long-running sort operation, this error message can repeat as frequently as once per minute while the query is running. In some cases, SQL Server might also be slow to respond to other requests. The article notes that, although Microsoft does support a fix for this problem, you should apply the fix only to specific machines that are experiencing the scheduler response problem. You can obtain the hotfix and read about the problem at
http://support.microsoft.com/default.aspx?scid=kb;en-us;814693 .

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish