如想在MSSQL中建立資料庫圖表,但又遇到如下錯誤:
"Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."
解決方式:
- 選擇資料庫(Database) > 右點擊 > 選擇屬性(Properties)
- 選擇左方的Files
- 在Owner欄位,點選「…」按鈕
- 選擇「sa」或「NT AUTHORITY\SYSTEM」,點擊完成
鏈結到這頁!