Re: sql server 2005 - database diagram problem

You need to change the compatability level of the database to 90 (SQL2005)
to create the objects

EXEC sp_dbcmptlevel 'databasename', 90

This will be fixed in SP1 I believe.

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com


"Filip De Backer" <filip_de_backer@xxxxxxxxxxxx(donotspam)> wrote in message
news:D65EF6EB-4CF2-45D7-9897-8AA5F672725A@xxxxxxxxxxxxxxxx
Hi everyone,

I've want to create a database diagram I got the following error:
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.

The database was owned by user Filip.
I've changed the owner to sa.
But the problem still remains.

When I created a brand new database and copied the tables to that
database,
the problem was fixed.
But that is a stupid solution.
All my databases have this problem.
Even when I'm logged in as Filip instead of sa.

thanks!

Filip




.

Relevant Pages

  • Re: SQL 2005 Express-Database does not have a valid owner?
    ... That means that the database's owner is MYDOMAIN\MyUserName ... My design machine is running Windows XP Pro. ... database diagram. ... Database diagram support objects cannot be installed because this ...
    (microsoft.public.sqlserver.security)
  • Re: conflicting object names in sql server 2000
    ... The owner of the object will depend on the user ... On the local database server when it does the select * from ... she must specify the owner: ...
    (microsoft.public.sqlserver.server)
  • Re: unknown database owner
    ... cleared for the 'Admin' user. ... the "owner is unknown" (you described ... An old database, ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: Cross database update issue
    ... Also, for dbo-owned objects, the owner of both databases must be the ... You can execute sp_helpdb to determine the current database owners. ... > User Name: Test1 Role Name=Test ... > Role Test has select permission to table t_test ...
    (microsoft.public.sqlserver.security)
  • Re: Cant access any old tables
    ... I used the same access rights to test the table in the different database. ... Is there a place to set a TABLE owner separate from the database owner? ... but one was SQL based and the other Windows Secured. ...
    (microsoft.public.sqlserver.security)