建站
咨詢
售后
建站咨詢
新聞中心
文章主要描述的是正確解決SQL Server 2000Bug的實(shí)際操作。以及對(duì)其在實(shí)際操作中的工作環(huán)境，以及對(duì)相關(guān)的運(yùn)行結(jié)果的描述，以下就是相關(guān)內(nèi)容的具體描述，希望會(huì)給你帶來(lái)一些幫助在此方面。
網(wǎng)站建設(shè)哪家好，找創(chuàng)新互聯(lián)建站！專注于網(wǎng)頁(yè)設(shè)計(jì)、網(wǎng)站建設(shè)、微信開(kāi)發(fā)、小程序制作、集團(tuán)企業(yè)網(wǎng)站建設(shè)等服務(wù)項(xiàng)目。為回饋新老客戶創(chuàng)新互聯(lián)還提供了薩迦免費(fèi)建站歡迎大家使用！
1.異常信息
通過(guò)SQL Server Enterprise Manager來(lái)修改table結(jié)構(gòu)時(shí)，出現(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)時(shí)是為了修復(fù)Microsoft Reporting Services V1.0的SQL Server 2000Bug才安裝的)
Windows Server 2003
3.查看Select @@Version 運(yùn)行結(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)提供了對(duì)應(yīng)的hotfix來(lái)解決上述問(wèn)題，不過(guò)需要聯(lián)系Microsoft Support Services來(lái)獲取hotfix。我沒(méi)有在網(wǎng)上發(fā)現(xiàn)該hotfix的下載。
目前，Microsoft SQL Server 2004 Service Pack 4.0(處于測(cè)試階段)還沒(méi)有正式推出，郁悶。只好通過(guò)Query Analyzer使用SQL Script腳本來(lái)完成，如:
ALTER TABLE AppRemotingLogger ALTER COLUMN Message VARCHAR(800)
(修改數(shù)據(jù)表AppRemotingLogger的Message字段)
Updated:
根據(jù)bengxia的指點(diǎn)，可以從如下的URL下載到了SQL2000-KB810185-8.00.0878-ENU.exe 。下載地址為:http://support.microsoft.com/?kbid=838166
上述hotfix修復(fù)了該SQL Server 2000Bug。
網(wǎng)站標(biāo)題：遇到SQLServer2000Bug不可怕！
文章網(wǎng)址：http://www.dlmjj.cn/article/dhocsji.html
