织梦CMS - 轻松建站从此开始!

罗索

How to solve the problem:Drop failed for User \'SQL2K5User\'

罗索客 发布于 2008-03-20 17:07 点击:次 
How to solve the question \"Drop failed for User \'SQL2K5User\'. \" TITLE: Microsoft SQL Server Management Studio ------------------------------ Drop failed for User \'SQL2K5User\'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/
TAG:

How to solve the question "Drop failed for User 'SQL2K5User'. "
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')

(iwgh)
本站文章除注明转载外,均为本站原创或编译欢迎任何形式的转载,但请务必注明出处,尊重他人劳动,同学习共成长。转载请注明:文章转载自:罗索实验室 [http://www.rosoo.net/a/200803/6915.html]
本文出处: 作者:iwgh
顶一下
(0)
0%
踩一下
(0)
0%
------分隔线----------------------------
发表评论
请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
评价:
表情:
用户名: 验证码:点击我更换图片
栏目列表
将本文分享到微信
织梦二维码生成器
推荐内容