首页 > 数据库技术 > 详细

Rename failed for user 'dbo' -MS SQL ERROR 15150

时间:2020-06-11 20:27:30      阅读:113      评论:0      收藏:0      [点我收藏+]

 

SQL SERVER 2016修改“User Mapping"时报错:

TITLE: Microsoft SQL Server Management Studio
------------------------------
Rename failed for User ‘dbo‘.  (Microsoft.SqlServer.Smo)
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.37971.0&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Rename+User&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot alter the user ‘dbo‘. (Microsoft SQL Server, Error: 15150)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=13.00.5026&EvtSrc=MSSQLServer&EvtID=15150&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------

技术分享图片

 

解决方法:

以SA登录SQL SERVER STUDIO,执行下面的命令:

use testdatabaseName
EXEC sp_changedbowner ‘sa‘,‘true‘

Rename failed for user 'dbo' -MS SQL ERROR 15150

原文:https://www.cnblogs.com/rusking/p/13095605.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!