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

The following error is returned when you want to add a relational table after attaching a database: The database does not have a valid owner, so you cannot install the database relational diagram support object. To continue, use the "file" page

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

One day, when debugging a program, suddenly found that after attaching a database, want to add a relational table, the result came out the following error: The database diagram support object cannot be installed because the database does not have a

Before using the database to create the diagram, the results reported this error. Then search for it.Transfer from http://www.cnblogs.com/muer/archive/2010/04/14/1711778.html This database does not have a valid owner and therefore cannot install

The database tutorial does not have a valid owner, so the database diagram support object cannot be installed. To continue, first set the database owner to a valid login using the file page of the Database Properties dialog box or the ALTER

A, create table-a new table CREATE [Temporary | TEMP] Table Table (Column type[NULL | Not NULL] [UNIQUE] [DEFAULT value][Column_constraint_clause | PRIMARY KEY} [...]][, ... ][, PRIMARY KEY (column [, ...])][, CHECK (condition)][,

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

Note: Someone else gave me a database backup file. After I restored it locally, I planned to create a database digoal. the following error occurs: Error message: Database digoal support objects cannot be installed because this database does not

After you create a new database or attach a database, you want to add a relational table, resulting in the following error: The database diagram support object cannot be installed because the database does not have a valid owner. To continue, first