April 22, 2010 at 12:18 am
I have restored datase from backup that provided by client. Now I want to prepare database diagram for restored database. When I click on "New Database Diagram", Sql Server shows me following message -
"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."
I have done following initial checking
1. Verfied Owner of Database (it is already set to my account)
2. Compatiablity Level (it is set to SQL Server 2008 (100))
Please let me know how to avoid warning and create database diagram.
Thanks in advance
Vinayak
April 22, 2010 at 3:45 am
This was removed by the editor as SPAM
April 22, 2010 at 6:54 am
Thanks, It worked !!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply