Re: Invalid cursor state

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 03/14/04 

Date: Sun, 14 Mar 2004 17:29:39 -0500

Now, why does column order matter? Or is this just a cosmetic thing? 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Dean Slindee" <slindee@mindspring.com> wrote in message
news:OrLl8SgCEHA.464@TK2MSFTNGP11.phx.gbl...
> Thanks for your reply.
>
> After fiddling with it some more, the problem occurs when trying to insert
a
> column
> between other columns, but does not occur when appending the column at the
> end
> of the table.  I dealt with it by creating an empty table the way it
wanted
> it arranged,
> and inserting from the legacy table, and deleting the old table and
renaming
> the new table.  Problem bypassed.
>
> Dean Slindee
>
> "Erland Sommarskog" <sommar@algonet.se> wrote in message
> news:Xns94ACB21EEC540Yazorman@127.0.0.1...
> > Dean Slindee (slindee@mindspring.com) writes:
> > > I get the following message when attempting to insert a new column
into
> a
> > > table in design mode:
> > > - Unable to modify table.
> > > ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
> > >
> > > Only SQL Server 2000 is connected to the database.
> > > What does this mean and how does one fix it?
> >
> > I say that this is a bug in Enterprise Manager. The user should never
> > see any error like this.
> >
> > I have no idea what may have happened, but did you try to close down
> > EM, and start anew?
> >
> > Myself, and many other experience SQL professionals, prefer to use
> > SQL statements to change tables. Here is an example of the syntax for
> > adding column to a table is:
> >
> >    ALTER TABLE tbl ADD col int NULL
> >
> >
> > -- 
> > Erland Sommarskog, SQL Server MVP, sommar@algonet.se
> >
> > Books Online for SQL Server SP3 at
> > http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>
>

Relevant Pages