Alter table does not work on SQL Server 2000 with SP3a and Hotfix KB810185

Greetings !
I am having problem with ALTER TABLE on any table when I install Hotfix
(KB810185-8.00.0859-ENU) required for SQL Server Reporting services.
I have installed SQL Server 2000 Enterprise Edition with SP3a on Windows
2003 Server (Standard Edition)
Hardware characteristics: Intel Pentum IV 2.40 GHz, 2 GB RAM, 5 disks etc.
We have tested alter table on two different computers and problem is the
same.
We have tried in Enterprise Manager and Query Analyser.
In Query Analyser sometimes is possible, but not all the time.
Without Hotfix (KB810185) everthing works fine.
Please help.
Is it possible to uninstall this hotfix?
It is not visible in ADD/REMOVE Programs ?
Regards Gjuro.What is the exact ALTER TABLE statement that is failing, and how do you
know it fails? Do you get an error, does it simply not change the
table, or something else?
SK
Dariviko wrote:
>Greetings !
>I am having problem with ALTER TABLE on any table when I install Hotfix
>(KB810185-8.00.0859-ENU) required for SQL Server Reporting services.
>I have installed SQL Server 2000 Enterprise Edition with SP3a on Windows
>2003 Server (Standard Edition)
>Hardware characteristics: Intel Pentum IV 2.40 GHz, 2 GB RAM, 5 disks etc.
>We have tested alter table on two different computers and problem is the
>same.
>We have tried in Enterprise Manager and Query Analyser.
>In Query Analyser sometimes is possible, but not all the time.
>Without Hotfix (KB810185) everthing works fine.
>
>Please help.
>Is it possible to uninstall this hotfix?
> It is not visible in ADD/REMOVE Programs ?
>Regards Gjuro.
>
>|||---
Test table creation: (Script from Enterprise Manager - New table)
----
/*
17. veljaca 2004 16:49:35
User:
Server: MSSERVER
Database: MFIN_TEST
Application: MS SQLEM - Data Tools
*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
CREATE TABLE dbo.Table_TEST
(
id int NOT NULL,
col1 char(10) NULL,
col2 char(10) NULL
) ON [PRIMARY]
GO
COMMIT
--
Table is successfuly created.
When I move ALLOW NULLS from col2 in Enterprise Manager, I receive error in
Enterprise Manager.
/*
17. veljaca 2004 16:51:40
User:
Server: MSSERVER
Database: MFIN_TEST
Application: MS SQLEM - Data Tools
*/
---
ALTER TABLE in Enterprise Manager
---
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
CREATE TABLE dbo.Tmp_TABLE_TEST
(
id int NOT NULL,
col1 char(10) NULL,
col2 char(10) NOT NULL
) ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.TABLE_TEST)
EXEC('INSERT INTO dbo.Tmp_TABLE_TEST (id, col1, col2)
SELECT id, col1, col2 FROM dbo.TABLE_TEST TABLOCKX')
GO
DROP TABLE dbo.TABLE_TEST
GO
EXECUTE sp_rename N'dbo.Tmp_TABLE_TEST', N'TABLE_TEST', 'OBJECT'
GO
COMMIT
--
This is an error I receive:
--
/*
17. veljaca 2004 16:52:07
User:
Server: MSSERVER
Database: MFIN_TEST
Application: MS SQLEM - Data Tools
*/
'TABLE_TEST' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
Table TABLE_TEST is empty. New table
Windows 2003 Server has all updates.
I tried to remove hotfix KB810185 as it is described on Microsoft site, but
it does not work.
Regards
Gjuro MCDBA
"Steve Kass" <skass@.drew.edu> wrote in message
news:uS5Yl8V9DHA.2472@.TK2MSFTNGP10.phx.gbl...
> What is the exact ALTER TABLE statement that is failing, and how do you
> know it fails? Do you get an error, does it simply not change the
> table, or something else?
> SK
> Dariviko wrote:
> >Greetings !
> >
> >I am having problem with ALTER TABLE on any table when I install Hotfix
> >(KB810185-8.00.0859-ENU) required for SQL Server Reporting services.
> >
> >I have installed SQL Server 2000 Enterprise Edition with SP3a on Windows
> >2003 Server (Standard Edition)
> >Hardware characteristics: Intel Pentum IV 2.40 GHz, 2 GB RAM, 5 disks
etc.
> >
> >We have tested alter table on two different computers and problem is the
> >same.
> >We have tried in Enterprise Manager and Query Analyser.
> >In Query Analyser sometimes is possible, but not all the time.
> >Without Hotfix (KB810185) everthing works fine.
> >
> >
> >Please help.
> >
> >Is it possible to uninstall this hotfix?
> > It is not visible in ADD/REMOVE Programs ?
> >
> >Regards Gjuro.
> >
> >
> >
> >
>|||I am having the same exact problem except when using Enterprise Manager.
I am trying to modify an existing table, and when I click the Save icon, I
get a message about Invalid Cursor State. This is only AFTER I applied
Hotfix 821334 in order to use SQL Reporting Services. As in Dariviko's case,
I am also running Server 2003 with SQL Server 2000 and SP3a. I installed
Reporting Services yesterday and the 821334 hotfix as a part of that
installation.
Does anybody else get this error?
Thanks,
Michael Carr
"Dariviko" <dariviko@.hotmail.com> wrote in message
news:c0te4m$pq4$1@.sunce.iskon.hr...
> --
> This is an error I receive:
> --
> /*
> 17. veljaca 2004 16:52:07
> User:
> Server: MSSERVER
> Database: MFIN_TEST
> Application: MS SQLEM - Data Tools
> */
> 'TABLE_TEST' table
> - Unable to modify table.
> ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
>
> Table TABLE_TEST is empty. New table
> Windows 2003 Server has all updates.
> I tried to remove hotfix KB810185 as it is described on Microsoft site,
but
> it does not work.
> Regards
> Gjuro MCDBA
>
>
>
> "Steve Kass" <skass@.drew.edu> wrote in message
> news:uS5Yl8V9DHA.2472@.TK2MSFTNGP10.phx.gbl...
> > What is the exact ALTER TABLE statement that is failing, and how do you
> > know it fails? Do you get an error, does it simply not change the
> > table, or something else?
> >
> > SK
> >
> > Dariviko wrote:
> >
> > >Greetings !
> > >
> > >I am having problem with ALTER TABLE on any table when I install Hotfix
> > >(KB810185-8.00.0859-ENU) required for SQL Server Reporting services.
> > >
> > >I have installed SQL Server 2000 Enterprise Edition with SP3a on
Windows
> > >2003 Server (Standard Edition)
> > >Hardware characteristics: Intel Pentum IV 2.40 GHz, 2 GB RAM, 5 disks
> etc.
> > >
> > >We have tested alter table on two different computers and problem is
the
> > >same.
> > >We have tried in Enterprise Manager and Query Analyser.
> > >In Query Analyser sometimes is possible, but not all the time.
> > >Without Hotfix (KB810185) everthing works fine.
> > >
> > >
> > >Please help.
> > >
> > >Is it possible to uninstall this hotfix?
> > > It is not visible in ADD/REMOVE Programs ?
> > >
> > >Regards Gjuro.
> > >
> > >
> > >
> > >
> >
>|||I have them same problem. See http://www.aspfaq.com/show.asp?id=2515. Now we just need a Microsoft tech to tell us where we can download hotfix 876 or greater.|||You call Microsoft Product Support Services, just like the KB articles say.
(You can find individual hotfixes at http://www.aspfaq.com/2160)
You won't be able to find hotfixes available at tucows or download.com.
They keep them from public consumption for a reason...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"David Hubbell" <David.Hubbell@.sierras.com> wrote in message
news:D52EBDF9-A0DC-4723-A123-D1FE4B47747D@.microsoft.com...
>I have them same problem. See http://www.aspfaq.com/show.asp?id=2515. Now
>we just need a Microsoft tech to tell us where we can download hotfix 876
>or greater.