A few days ago, because the domain administrator account was accidentally deleted, a new one was created. Then, the database administrator account can only be deleted and rebuilt. However, some problems are found during use and the database attributes cannot be read. The following error message is displayed when the attribute dialog box is opened:
Title: Microsoft SQL Server Management Studio
------------------------------
The request dialog box cannot be displayed.
------------------------------
Other information:
The request dialog box cannot be displayed. (Sqlmgmt)
------------------------------
The property owner cannot be used in the Database "[jkl_dw]". This object may not have this attribute or cannot be retrieved due to insufficient access permissions. (Microsoft. sqlserver. SMO)
For help information, click:Http://go.microsoft.com/fwlink? Prodname = Microsoft + SQL + server & prodver = 10.0.1600.22 + (SQL _prerelease ). 080709-1414 +) & evtsrc = Microsoft. sqlserver. management. SMO. predictiontemplates. propertycannotberetrievedexceptiontext & evtid = owner & linkid = 20476
After searching for the information online, the error message is that the db_owner owner encountered an exception.
Change the database owner and execute "Exec sp_changedowner 'sa '" to the database.