I'm developing a DB with SQL 7.0 I've created a table with an integer
field. Every record has 0 in this field. I've changed my mind and would
like to change the data type to decimal. When I attempt to make this
change, I get the "Invalid Cursor State" error. I've tried deleting the
field and recreating it, with the same result. The DB and logs are well
below their maximum size limits.
What's going on? Do I need to delete the whole table and re-create it?