Database relationship diagram "prompt: this database does not have a valid owner

After restoring the database backed up by sql2000 to sql2005, the "database relationship diagram" prompt: the database does not have a valid owner, so you cannot install the database relationship diagram support object "SOLUTION

After restoring the database backed up by sql2000 to sql2005, the "database relationship diagram" prompt: the database does not have a valid owner, so you cannot install the database relationship diagram support object. To continue, first set the database owner to a valid login name using the "file" page or the alter authorization statement in the "database properties" dialog box, and then add a database relational diagram support object.

The solution is as follows:

1. Set the compatibility level to 90 (2005 to 90)

USE [master]

GO

EXEC dbo. sp_dbcmptlevel @ dbname = 'database name', @ new_cmptlevel = 90

GO

Or select the database you want to restore, right-click it, select Properties-> options-> Compatibility Level, select sqlserver2005 (90), and then click OK,

When you expand the "database relationship diagram" node under the database, you will be prompted, "This database lacks one or more support objects required to use the database relationship diagram, whether to create ", select "yes.

2. If the problem persists after performing the above operations, continue as follows:

Select your database, select "security"-> "user", and select dbo to open the attribute page. If the logon name is empty, create a new query and

Use [your database name]

EXEC sp_changedbowner 'sa'

After the execution is successful, select the "database relationship diagram" node and prompt "this database lacks one or more support objects required to use the database relationship diagram, whether to create ", select "yes. You can see the previously created graph.

3. Generally, the problem can be solved in the first two steps. The third method is to use the ALTER command.

Exception: the database does not have a valid owner. Therefore, the database relational diagram support object cannot be installed. When you restore the database backed up from another machine to your machine and click the database relationship diagram of this database in SSMS, the following prompt is displayed:

The database does not have a valid owner, so you cannot install the database relational diagram support object. To continue, first set the database owner to a valid login name using the "file" page or the alter authorization statement in the "database properties" dialog box, and then add a database relational diagram support object.

The database is determined to have a database relationship diagram. The following two methods are provided: the first method is difficult to use after several attempts, and the second method is successful. Specifically, run the following command in SSMS:

Alter authorization on database: mydbname TO sa

Modify mydbname to the actual database name, and set the owner to sa.

For detailed parameters of alter authorization, refer to the following address:

Http://msdn2.microsoft.com/zh-cn/library/ms187359.aspx