Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2001-04-23 : 12:51:29
|
| We are experiencing strange problems with SQL Server 7. We accidentally removed all users from the sysusers table (except ones beginning with db...) for a database and we now seem unable to modify existing tables.If we try to change a field size we get a message saying...-Unable to preserve security settings for user ?1ODBC error.....there is no such user or group ?1Does anyone have any ideas as to the problem please.Have we deleted any crucial users ??Should there be an Administrator user ??We did have an INFORMATION_SCHEMA user in there as well.Will re-installing SQL Server restore default users ?any help much obliged |
|
|
|
|
|
Strange behaviour......