遇到SQL Server 2000Bug不可怕！
文章主要描述的是正確解決SQL Server 2000Bug的實際操作。以及對其在實際操作中的工作環(huán)境，以及對相關(guān)的運行結(jié)果的描述，以下就是相關(guān)內(nèi)容的具體描述，希望會給你帶來一些幫助在此方面。
1.異常信息
通過SQL Server Enterprise Manager來修改table結(jié)構(gòu)時，出現(xiàn)如下異常:ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2.工作環(huán)境:
MS SQL Server 2004 SP3a
SQL Server Hot fix 8.00.0859 (當(dāng)時是為了修復(fù)Microsoft Reporting Services V1.0的SQL Server 2000Bug才安裝的)
Windows Server 2003
3.查看Select @@Version 運行結(jié)果:
- 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的相關(guān)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已經(jīng)提供了對應(yīng)的hotfix來解決上述問題，不過需要聯(lián)系Microsoft Support Services來獲取hotfix。我沒有在網(wǎng)上發(fā)現(xiàn)該hotfix的下載。
目前，Microsoft SQL Server 2004 Service Pack 4.0(處于測試階段)還沒有正式推出，郁悶。只好通過Query Analyzer使用SQL Script腳本來完成，如:
ALTER TABLE AppRemotingLogger ALTER COLUMN Message VARCHAR(800)
(修改數(shù)據(jù)表AppRemotingLogger的Message字段)
Updated:
根據(jù)bengxia的指點，可以從如下的URL下載到了SQL2000-KB810185-8.00.0878-ENU.exe 。下載地址為:http://support.microsoft.com/?kbid=838166
上述hotfix修復(fù)了該SQL Server 2000Bug。
【編輯推薦】
- SQL Server性能進行提高的4項技術(shù)概述
- SQL Server數(shù)據(jù)轉(zhuǎn)換服務(wù)的妙招之一
- SQL Server數(shù)據(jù)庫的妙招用法
- SQL Server數(shù)據(jù)轉(zhuǎn)換服務(wù)利用與導(dǎo)入式格式的描述
- 正確維護Sql Server表索引的2個步驟
