In SQL Server Management Studio do the following: Right Click on your database, choose properties Go to the Options Page In the Drop down at right labeled "Compatibility Level" choose "SQL Server 2005(90)" 3-1. choose "SQL Server 2008" if you receive a comparability error. Go to the Files Page Enter "sa" in the owner textbox. 5-1 or click on the ellipses(...) and choose a rightful owner. Hit OK after doing this, You will now be able to access the Database Diagrams.
Mayank Gupta's blog contains posts related to important Programming , Web Development Concepts, issues and solutions.
Comments
Post a Comment