07-06 03:03 阅读 66

The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'

The database owner SID recorded in the master database differs from the database owner SID recorded in database ‘DB_NAME‘. You should correct this situation by resetting the owner of database ‘DB_NAME‘ using the ALTER AUTHORIZATION statement.

主数据库中记录的数据库所有者SID与数据库‘DB_NAME‘中记录的数据库所有者SID不同。您应该通过使用ALTER AUTHORIZATION语句重新设置数据库“DB_NAME”的所有者来纠正这种情况。

解决办法：

DECLARE @Command VARCHAR(MAX) = ‘ALTER AUTHORIZATION ON DATABASE::<> TO [<>]‘ 

SELECT @Command = REPLACE(REPLACE(@Command 
            , ‘<>‘, DB_NAME())
            , ‘<>‘, sp.name)
FROM sys.databases db JOIN
        sys.server_principals sp ON sp.sid = db.owner_sid
WHERE db.name = ‘master‘

EXEC(@Command)
GO

Source Code

原文：https://www.cnblogs.com/insus/p/15202514.html

推荐资源

[前端实战] JS实战开发联动日历/瀑布流/分页特效/下拉菜单等等功能视频教程 2020年中级安全工程师安全生产专业实务习题集之建筑施工安全百度云网盘下载手机剪辑赚钱课，抓住短视频风口剪出百万爆款视频，实操小白3周赚到20000 （无水印）潭州软件测试工程师精英培训班（Web自动化+APP自动化+接口自动化+面试） Spring Boot 升级版最新教程全面讲解【通俗易懂】 Get全栈技能点 Vue2.0/Node.js/MongoDB 打造商城系统视频教程 Node全栈开发教程数据思维：让大脑更清醒（套装4册） PDF电子书下载设计模式之美完结抖音同城相亲交友教学，抓住红利月入过10W+ 价值888元极客时间-微服务架构核心20讲视频教程微服务视频教程

The database owner SID recorded in the master database differs from the database owner SID recorded in database &#39;DB_NAME&#39;

The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'