Unanswered: Can't add fields to table in EM - Odd SP3a prob?
Ok, I think this is a SP3a issue but I wanted to know if anyone else had this same problem.
I am trying to add fields to an existing table but everytime I do, I get a message saying:
- Unable to create index 'IX_Races2'.
ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
I have narrowed it down to this. I can add the field if I add it to the bottom of the field list AND make it allow NULL. BUT...if I try to move the column up to another position (no, I don't need it in that position I know), it throws the error.
Also, if I add the field to the bottom of the field list, then try take off the NULL and fill in a default value, it still throws me this error. Someone tell me that this is just a SP3a issue. I have done this kind of thing before and never ran across this problem before.