none
DB role unable to delete-The database principal owns a schema in the database, and cannot be dropped.

    Question

  • I created a role . Initially when I created schema assigned as dbo. now I change back to  role1 as image. But I am unable to drop the role.

    I run following commands

    ALTER

    AUTHORIZATIONONROLE::[role1] TO[role1];

    Still getting following error

    Drop failed for DatabaseRole 'role1'.  (Microsoft.SqlServer.Smo)

    The database principal owns a schema in the database, and cannot be dropped.

    Any one can help me on . Great Thanks


    Monday, May 28, 2018 3:44 AM

All replies