Friday, March 9, 2012

Error, when alter table

Hi,
on a SQL Server 200 installed on a Win2003 Std. Server, we get an error in any Databse when trying to 'alter table'
The error says something like 'Cursor not vaild' or in German 'Ungueltiger Cursorstatus'
Any ideas?
Thanks in advanceDid you try running an explicit ALTER TABLE statement in Query Analyzer,
instead of making changes using Enterprise Manager?
http://www.aspfaq.com/2515
--
http://www.aspfaq.com/
(Reverse address to reply.)
"DOKOM@.community.nospam" <DOKOM@.community.nospam@.discussions.microsoft.com>
wrote in message news:A51F71F0-A5DD-43B9-B849-B3B26759C929@.microsoft.com...
> Hi,
> on a SQL Server 200 installed on a Win2003 Std. Server, we get an error in
any Databse when trying to 'alter table'
> The error says something like 'Cursor not vaild' or in German 'Ungueltiger
Cursorstatus'
> Any ideas?
> Thanks in advance|||> some asp-Scripts do not work when performing a 'rs.Update'
Call a stored procedure or use an UPDATE statement to perform an update.
Don't use a heavy, lock-intensive recordset object...
http://www.aspfaq.com/2191
--
http://www.aspfaq.com/
(Reverse address to reply.)|||> If it is the only chance I'd prefer installing a new instance of the
SQL-Server without the above mentioned Patch.
Did you actually read the whole article I referenced? Here it is again,
just in case:
http://www.aspfaq.com/2515
--
http://www.aspfaq.com/
(Reverse address to reply.)

No comments:

Post a Comment