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

clip_image001

We will see this error on clicking in on Diagram

clip_image002

Lets dig more !!

clip_image003

What this message shows !!

clip_image004

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

clip_image005

Following is way how we should fix this

On Database right click n click on properties

clip_image006.

It will open following window with lot of Database information

clip_image007

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 

clip_image008

Change this to sa

clip_image009

Now lets gain try one last time

clip_image001[1]

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

clip_image010

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

clip_image011

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

About these ads
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 )

Google+ photo

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

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,120 other followers

%d bloggers like this: