Database diagrams cannot be viewed after attaching a database, and database diagrams cannot be established
My solution is as follows:
1, set the compatibility level is 90 (2005 is 90) (2000 is 80)
Copy Code code as follows:
Use [master]
Go
EXEC dbo.sp_dbcmptlevel @dbname = ' database name ', @new_cmptlevel =90
Go
[This command completes:] The DBCC execution is complete. If DBCC outputs an error message, contact your system administrator. "No matter what it is, then click on" Database Diagram ", the report" This database is missing one or more supporting objects to use the database diagram, whether to create ", select" Yes ", problem solved.
Or select the database you restored, right-click, select attribute-> option-> compatibility level, choose sqlserver2005 (90) and then OK.
At this point, you will be prompted to expand the database Diagram node under the database, "This database is missing one or more supporting objects that are required to use the database diagram, create", and select Yes.
2, through the above methods of operation, if the problem persists, in the following ways to continue
Select your database and select "Security"-> "user", select dbo, open the Properties page, if the login name is empty, create a new query, and then
Copy Code code as follows:
Use [your database name]
EXEC sp_changedbowner ' sa '
After successful execution, you will then select the Database Diagram node and prompt "This database is missing one or more supporting objects required to use the database diagram, create", and select Yes. You can see the original diagram.