建站
咨詢
售后
建站咨詢
新聞中心
文章主要描述的是正確解決SQL Server 2000Bug的實際操作。以及對其在實際操作中的工作環(huán)境，以及對相關(guān)的運行結(jié)果的描述，以下就是相關(guān)內(nèi)容的具體描述，希望會給你帶來一些幫助在此方面。
網(wǎng)站建設(shè)哪家好，找創(chuàng)新互聯(lián)建站！專注于網(wǎng)頁設(shè)計、網(wǎng)站建設(shè)、微信開發(fā)、小程序制作、集團企業(yè)網(wǎng)站建設(shè)等服務(wù)項目。為回饋新老客戶創(chuàng)新互聯(lián)還提供了薩迦免費建站歡迎大家使用！
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。
網(wǎng)頁名稱：遇到SQLServer2000Bug不可怕！
鏈接分享：http://www.5511xx.com/article/dhocsji.html
