在MS-SQL-SERVER里 Database Diagrams 上右键新建一个数据库关系视图时,不能建立。弹出如下提示:
TITLE: Microsoft SQL Server Management Studio
------------------------------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.------------------------------
BUTTONS:OK
------------------------------
各位前辈指点一下!数据库SQL Server
TITLE: Microsoft SQL Server Management Studio
------------------------------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.------------------------------
BUTTONS:OK
------------------------------
各位前辈指点一下!数据库SQL Server
Server name: WWW1B
Authentication: windows Authentication
User name: WWW1B\Administrator
理论上来说,windows的admin是有权限的。不过你还是查看一下WWW1B\Administrator有没有此数据库的
db_ower角色
http://wenku.baidu.com/view/70ffd05b312b3169a451a42b.html