Unable to create table

[rphips]

Hello , I hope someone can assist>

The problem I ran into seems simple but I think I lost my mind.

Anyway I created a database and assigned a group as dbo

Now when anybody in the group tries to create a table they get the following error>

- Unable to create table.
ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state

Can anybody answer why? And point me to a cure?

rphips

 

[Corran007]

ususally what i do is assign the actually dbo to the sa account. then i grant dbo privlages to those who need them. im wondering if the server is having problems since one person does not own it. I would try switching the db owner to sa and then grant dbo privlages to that group.

 

[JamesLean]

How are these users trying to create tables?

--James