The database relationship View bitsCN.com cannot be displayed.
The solution is as follows:
1. set the compatibility level to 90 (2005 to 90)
USE [master]
GO
EXEC dbo. sp_dbcmptlevel @ dbname = 'database name', @ new_cmptlevel = 90
GO
Or select the database you want to restore, right-click it, select Properties-> Options-> compatibility level, select sqlserver2005 (90), and then click OK,
When you expand the "database relationship diagram" node under the database, you will be prompted, "This database lacks one or more support objects required to use the database relationship diagram, whether to create ", select "yes.
2. if the problem persists after performing the above operations, continue as follows:
Select your database, select "security"-> "user", and select dbo to open the attribute page. if the logon name is empty, create a new query and
Use [your database name]
EXEC sp_changedbowner 'sa'
Run bitsCN.com
