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 |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2009-08-27 : 14:30:14
|
| I restored a database and the users that were restored are causign issues i.e. I can't seem to be able to add any other use on the database.Also, I can't delete any users that didn't exist before importing and it says it is the principal user.It says 'drop failed for user xxx, database principal owns a schema in the database. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-27 : 16:32:37
|
| make a different user schema owner. then u can drop the user(s) |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2009-08-27 : 16:34:20
|
| Assign schema to another user, the drop user |
|
|
|
|
|
|
imported db, and users that are imported