none
Drop db_owner user from database sql server 2008

    Question

  • Dear all,

    I have a problem delete an user from sql server 2008 R2.

    i have delete user "dataAdmin" from server but i forget to delete from accounting database.

    when i tried to delete there is an error :

    Drop failed for User 'dataAdmin'.  (Microsoft.SqlServer.Smo)
    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
    The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)

    how can i delete that user.Please help.

    Best regards,

    Surbakti

    Wednesday, September 11, 2013 3:50 AM

Answers