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)
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.