遇到SQL Server 2000Bug不可怕！
文章主要描述的是正確解決SQL Server 2000Bug的實際操作。以及對其在實際操作中的工作環境，以及對相關的運行結果的描述，以下就是相關內容的具體描述，希望會給你帶來一些幫助在此方面。
1.異常信息
通過SQL Server Enterprise Manager來修改table結構時，出現如下異常:ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2.工作環境:
MS SQL Server 2004 SP3a
SQL Server Hot fix 8.00.0859 (當時是為了修復Microsoft Reporting Services V1.0的SQL Server 2000Bug才安裝的)
Windows Server 2003
3.查看Select @@Version 運行結果:
- 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: )
4.Microsoft的相關KB
- FIX: An invalid cursor state occurs after you apply Hotfix 8.00.0859 or later in SQL Server 2000
- URL: http://support.microsoft.com/kb/831997
- RESOLUTION:
- A supported hotfix is now available from Microsoft, but it is only intended to correct the problem
- that is described in this article. Only apply it to systems that are experiencing this specific problem.
- This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem,
- Microsoft recommends that you wait for the next Microsoft SQL Server 2000 service pack that contains this hotfix.
- To resolve this problem immediately, contact Microsoft Product Support Services to obtain the hotfix.
Microsoft已經提供了對應的hotfix來解決上述問題，不過需要聯系Microsoft Support Services來獲取hotfix。我沒有在網上發現該hotfix的下載。
目前，Microsoft SQL Server 2004 Service Pack 4.0(處于測試階段)還沒有正式推出，郁悶。只好通過Query Analyzer使用SQL Script腳本來完成，如:
ALTER TABLE AppRemotingLogger ALTER COLUMN Message VARCHAR(800)
(修改數據表AppRemotingLogger的Message字段)
Updated:
根據bengxia的指點，可以從如下的URL下載到了SQL2000-KB810185-8.00.0878-ENU.exe 。下載地址為:http://support.microsoft.com/?kbid=838166
上述hotfix修復了該SQL Server 2000Bug。
【編輯推薦】
- SQL Server性能進行提高的4項技術概述
- SQL Server數據轉換服務的妙招之一
- SQL Server數據庫的妙招用法
- SQL Server數據轉換服務利用與導入式格式的描述
- 正確維護Sql Server表索引的2個步驟
