I have this error message while trying to remove a user.
What should I do now?
Msg 15138, Level 16, State 1, Line 2
The database principal owns a schema in the database, and cannot be dropped.
TIA,
GunRemove the schema first (DROP SCHEMA), or change the owner of the schema (AL
TER AUTHORIZATION).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Gunawan" <jgun98.milis@.gmail.com> wrote in message news:u8M%23kNIXHHA.3948@.TK2MSFTNGP05.phx
.gbl...
>I have this error message while trying to remove a user.
> What should I do now?
> Msg 15138, Level 16, State 1, Line 2
> The database principal owns a schema in the database, and cannot be droppe
d.
> TIA,
> Gun
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment