Post reply

error when deleting user account after Restore DB

  • March 24, 2010 at 10:30 pm

    #217064

    After Restoring DB i'm not able to drop a user in the database, i checked if the user owns any objects in the db but there is non. Wen running the script

    "Msg 15138, Level 16, State 1, Line 1

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

    Please let me know how i can drop this user.

  • March 25, 2010 at 9:29 am

    #1139734

    In SSMS, expand the database, Security, Users, properties of the user you want to delete. The General pane of user properites shows the schemas owned by the user. Expand Security, Schemas, open properties of the specified schema and change the schema's owner to another user. Then you should be able to drop the user.

    Greg

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply