最進用sqlserver2008SR2 打開試圖設計器總是提示無法打開。搜索了一下做個備份。

USE “yourdb”; EXEC sp_changedbowner 'sa';

EXEC sp_dbcmptlevel 'yourdb', '90';goALTER AUTHORIZATION ON DATABASE::yourdb TO "sa"gouse [yourdb]goEXECUTE AS USER = N'dbo' REVERTgo