Databasediagram......dosenothaveavalidowner.解决方法

Database diagram support objects cannot be installed because this
database does not have a valid owner. To continue, first use the Files
page of the Database Properties dialog box or the ALTER AUTHORIZATION
statement to set the database owner to a valid login, then add the
database diagram support objects.

解决方法&＃xff1a;

1. 右键点击数据库&＃xff0c;选“properties ”
2. 点选左侧“Options”  
3. 在&＃39;Compatibility Level&＃39; 选 &＃39;SQL Server 2005(90)&＃39;
4. 点选左侧“Files”
5. 在owner里填入 &＃39;sa&＃39;  
6. OK

至此&＃xff0c;Diagrams目录可以使用了。

或者使用以下语句&＃xff1a;

EXEC sp_dbcmptlevel &＃39;数据库名&＃39;, &＃39;90&＃39;;
go
ALTER AUTHORIZATION ON DATABASE::数据库名TO "登录数据名"
go
use [数据库名]
go
EXECUTE AS USER &＃61; N&＃39;dbo&＃39; REVERT