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
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