Wednesday, February 15, 2012

Erro 15138

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 (ALTER 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 dropped.
> TIA,
> Gun
>

No comments:

Post a Comment