数据库设计器无法打开方法
最进用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
最进用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