When click "Database relationship diagram" in MsSQL, warning "此数据库没有有效所有者" will be shown up.
To fix this issue, just execute below sql to assign the privilege:
ALTER AUTHORIZATION ON database::YourDatabaseName TO sa
本文介绍了解决在MS SQL中点击“数据库关系图”时出现“此数据库没有有效所有者”警告的方法。只需执行一条简单的SQL语句即可为数据库分配权限。
When click "Database relationship diagram" in MsSQL, warning "此数据库没有有效所有者" will be shown up.
To fix this issue, just execute below sql to assign the privilege:
ALTER AUTHORIZATION ON database::YourDatabaseName TO sa
被折叠的 条评论
为什么被折叠?