Home > Query, ZeroToBasic > BISQL # 87 – Why DB Diagram doesn’t Work !! OR How to enable Database Diagram

BISQL # 87 – Why DB Diagram doesn’t Work !! OR How to enable Database Diagram

Hi friends ,

Today we will see how to get ready to use Database Diagram !!

I have observer that there is lot mystery behind many SQL Serve functionalities and use ..

But Sometime with proper guidance’s and some googleing we can resolve all mysteries

Here is one which I get most of the time which is I guess just installation setup error


We will see this error on clicking in on Diagram


Lets dig more !!


What this message shows !!


Frankly we will not get any anything from this  !! so just cut off it


Following is way how we should fix this

On Database right click n click on properties


It will open following window with lot of Database information


And see what there in Owner field : Domain name / User name which is the man problem Thumbs down what we re discussing ,So lets change this 


Change this to sa


Now lets gain try one last time


So this screen will pop up as this first Data base Diagram on Current DB


Click on yes and you are good to go to create new diagram


Ready to use !!

Hope this helps !!

Hope you will like this post on Select All for all table.

If you really like reading my blog and understood at lest few thing then please don’t forget to subscribe my blog .

If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog

Where todays links are

Link Resource Website

Categories: Query, ZeroToBasic
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: