Solved

View Database Diagram... how to modify database properties?

Posted on 2011-09-05
3
355 Views
Last Modified: 2012-05-12
MCTS Training Kit requires installation of a few databases. After installation, in attempt to view the database diagram, I am sked to change some database properties first.

Question: Could you please take a look the the following message and tell me how this handled?

Thank you
DatabaseDiagram.png
0
Comment
Question by:Mike Eghtebas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 4

Expert Comment

by:Sudhanshupathak
ID: 36486484
Chk this buddy it will help you and serve your purpose.

http://dotnetfish.blogspot.com/2008/11/database-diagram-support-objects-cannot.html
0
 
LVL 2

Accepted Solution

by:
awarren85 earned 500 total points
ID: 36486485
Hi, please try the following:

Select the database, right click it, select PROPERTIES. A pop up window opens up and in the upper left corner you'll see "SELECT A PAGE". select FILE. Now in the main section on the top you'll see OWNER. Select the button next to the empty box. another pop up box opens up, select browse and then you'll have to select (NT AUTHORITY\SYSTEM). that should do it and then you'll be able to see the DATABASE DIAGRAM.

Thanks, good luck!
0
 
LVL 34

Author Closing Comment

by:Mike Eghtebas
ID: 36487843
Thank you.
0

Featured Post

Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question