Error in creating DB diagram

Hi all,

When ever i tried to creat a diagram for the database i have i got this 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 version of the database i am working in was backed up from another machine

what is the problem and how can i solve it?

Thanks in advance

hi,

using SQL Server Management Studio Express, select the database node you have problems with.. access it's properties and, in the "Files" tab, set a valid login as the database owner... please verify the database is in "compatibility level 2005" 2005 too (Oprions tab)..

regards

|||

Hi,

I choosed "sa" as the database owner snd it works

Thanks alot