SQL Server Mentalist

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 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