A nasty bug in Microsoft SQL Server 2000

Microsoft SQL Server 2000A nastyBug

 

1. Exception Information

PassSQL Server Enterprise ManagerTo modifyTableStructure, the following exception occurs:

ODBC error: [Microsoft] [odbc SQL Server Driver] invalid cursor state

 

2. Work Environment:

Ms SQL Server 2004 sp 3A

SQL Server hot fix8.00.0859(It was for repair at the time.Microsoft Reporting Services V1.0OfBug)

Windows Server 2003

 

3. ViewSelect@ VersionRunning result:

Microsoft SQL Server2000-8.00.859 (Intel x86)SEP 18 2003 12:53:45Copyright (c) 1988-2003 Microsoft CorporationStandard Edition on Windows NT 5.2 (build 3790 :)

 

4.MicrosoftRelatedKB

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 The corresponding Hotfix To solve the problem, but you need to contact Microsoft support services To obtain Hotfix . I did not find this on the Internet Hotfix .

***

Currently,Microsoft SQL Server 2004 Service Pack 4.0(In the test phase) has not been officially launched, depressing.

You have to passQuery AnalyzerUseSQL scriptScript, such:

Alter table appremotinglogger alter column message varchar (800)

(Modify a data tableAppremotingloggerOfMessageField)

Updated:
The description of bengxia. you can download sql2000-kb810185-8.00109878-enu.exe from the URL.
Http://support.microsoft.com /? Kbid = 838166

The above hotfix fixes the bug.