Inavlid Cursor State

Hi pals,
I am asking you for help - I am using SQL server 2000 sp3, and have this
problem:
I create new dab, let say 'test_db', after I create 'Table1' with:
ID - Uniqueidentifier, PK
data - char (10), allow nulls
Ok, I close it, table is saved - this works, but problem comes here:
I open table via design table, and I want turn off 'allow nulls',
so I uncheck it, close it and I get this error:
'Table1' table
- Unable to create index 'PK_Table1'.
ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
And there errors I always get, when I want change something to the table.
Hm, not true - I can add new columns, but after I can't change them, for
example I can't set char(10) to char(20) and so on.
This is strange, have anyone some idea what it could be and how to avoid
this?
Thanks a lot
BranoSome info on this here:
http://www.aspfaq.com/2515
I recommend you make your database changes through code in Query
Analyzer rather than use Enterprise Manager. Regardless of the problem
you are having TSQL is more powerful and gives you more control.
--
David Portas
SQL Server MVP
--|||> http://www.aspfaq.com/2515
thanks a lot, patch http://support.microsoft.com/default.aspx/kb/838166
solve the problem.