Cannot create database diagrams

[Database Administrator]

Hi,

I am new to SQL 2005. I have recently setup SQL Server 2005 and retore a
database from SQL 2000. The database seem to be working except that It won't
allow me to chane or create new database diagram.

The following error:

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


SF

[Database Administrator]

Customize and run the following command batch:

EXEC sp_dbcmptlevel 'yourDB', '90';
go
ALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin"
go
use [yourDB]
go
EXECUTE AS USER = N'dbo' REVERT
go

--
Ekrem Önsoy



"SF" wrote in message
news:u6aQmvlNIHA.5860@TK2MSFTNGP04.phx.gbl...
> Hi,
>
> I am new to SQL 2005. I have recently setup SQL Server 2005 and retore a
> database from SQL 2000. The database seem to be working except that It
> won't allow me to chane or create new database diagram.
>
> The following error:
>
> 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
> ------------------------------
>
>
> SF
>

[Database Administrator]

Thank you Ekrem Önsoy

It work very well.

Sf

"Ekrem Önsoy" wrote in message
news:B940FE13-BD19-4BB8-834B-C04DE070A397@microsoft.com...
> Customize and run the following command batch:
>
> EXEC sp_dbcmptlevel 'yourDB', '90';
> go
> ALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin"
> go
> use [yourDB]
> go
> EXECUTE AS USER = N'dbo' REVERT
> go
>
> --
> Ekrem Önsoy
>
>
>
> "SF" wrote in message
> news:u6aQmvlNIHA.5860@TK2MSFTNGP04.phx.gbl...
>> Hi,
>>
>> I am new to SQL 2005. I have recently setup SQL Server 2005 and retore a
>> database from SQL 2000. The database seem to be working except that It
>> won't allow me to chane or create new database diagram.
>>
>> The following error:
>>
>> 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
>> ------------------------------
>>
>>
>> SF
>>
>