把数据从SQL2000导到SQl2005时打开关系图 提示错误 修正方法

把数据从SQL2000导到SQl2005时打开关系图 提示错误 修正方法

提示:

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

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

解决办法:

EXEC sp_dbcmptlevel database_name, 90
USE whichever_database
EXEC sp_changedbowner 'sa'