How to solve the question "Drop failed for User 'SQL2K5User'. "

最新推荐文章于 2024-01-08 13:50:50 发布

weixin_30896825

最新推荐文章于 2024-01-08 13:50:50 发布

阅读量123

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/autumn/articles/853442.html

版权

TITLE: Microsoft SQL Server Management Studio
------------------------------

Drop failed for User 'SQL2K5User'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+User&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

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)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=15138&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Solution:

1) Expand Schemas(should be like a folder under <yourdatabase> -> Security) .
2) Delete the unwanted "userSchema".
3) Then, go back to the User(a folder like thing) and delete it.

ps: select * from sys.schemas where principal_id = user_id('user_name')

转载于:https://www.cnblogs.com/autumn/articles/853442.html