I had a dastabase restored from anohter PC. Now when I database open database I am getting tables available in the database but when i click on database diagram it gives me error.
I have got a good solution in technet. Please go through the link to getsolve the problem
