数据库设计器无法打开方法

最进用sqlserver2008SR2  打开试图设计器总是提示无法打开。搜索了一下做个备份。


USE “yourdb”;
EXEC sp_changedbowner 'sa';


EXEC sp_dbcmptlevel 'yourdb', '90';
go
ALTER AUTHORIZATION ON DATABASE::yourdb TO "sa"
go
use [yourdb]
go
EXECUTE AS USER = N'dbo' REVERT
go

原文地址:https://www.cnblogs.com/liuyunsheng/p/3642930.html