|
Back
Database diagram support objects cannot be installed because this database does not have a valid owner
If you ever get this kind of error, use the following script. Update the script with your database name and login name.
EXEC sp_dbcmptlevel 'userdb', '90';
go
ALTER AUTHORIZATION ON DATABASE::'userdb'TO "userlogin"
go
use ['userdb']
go
EXECUTE AS USER = N'dbo' REVERT
go
Back
|
|