I am a Software Engineer.
My key interest are C#,SQL and some other latest technologies.
When i am researching on some thing.I am Updating my blog,for my backups.If this blog that help others.Then i am so happy.
Right click the Database Diagrams on the particular table and select new database diagram
Error i Got
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.
How i Solved
Right on database ,Choose properties
Go to options menu
check whether the compatibility level :SQL Server 2005(90)
Still i got the same error . After that i executed ALTER AUTHORIZATION ON DATABASE::DatabaseName TO sa