把数据从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'