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