Problems saving tables with EM

19 Jan 2005 4:45 PM

RafaÂ®

Me and my clients are having some problems, trying to save some table changes
in Enterprise Manager... The error looks like the following:
'ANDAMENTO' table
- Unable to create index 'IX_anda_dh_inclusao'.
ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state

table and index changes from table to table...
Anyways, if you copy the change script to query analyzer and execute it, you
get everything fine! Why EM gives me this errors?

19 Jan 2005 4:55 PM

Jasper Smith

Have a look at http://www.aspfaq.com/show.asp?id=2515
You will probably need to contact PSS to get a hotfix that includes the fix
for this issue

--
HTH

Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

Show quote

"Rafa®" <R***@discussions.microsoft.com> wrote in message
news:70CD7343-AE40-490B-8F91-EFBF2A4602FB@microsoft.com...
> Me and my clients are having some problems, trying to save some table
> changes
> in Enterprise Manager... The error looks like the following:
> 'ANDAMENTO' table
> - Unable to create index 'IX_anda_dh_inclusao'.
> ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
>
> table and index changes from table to table...
> Anyways, if you copy the change script to query analyzer and execute it,
> you
> get everything fine! Why EM gives me this errors?