关于MSSQL2005 数据库关系图无法使用

时间:2022-07-01 07:20:00
错误提示信息如下:
“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.”

原来是MSSQL2000使用【备份】的功能,导出bak格式的文件,还原到sqlserver2005的时候恢复过来的数据库的兼容级别还是默认80的。

解决办法:

1、设置兼容级别为90(2005为90)
USE [master]
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'数据库名', @new_cmptlevel=90
GO

2、
在该数据库下展开“数据库关系图”节点时会有个提示:
“This database does not have one or more of the support objects required to use database diagramming. Do you wish to create them? "
选择“是”即可。