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

[608 byte] By [Reta] at [2008-1-4]

«« MSFTE Errors during initial full-text index population
»» Unreliable results

# 1

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

AndreaMontanari at 2007-9-26 >