Sql-server – Property Owner is not available for Database ‘DBNAME’

sql serversql-server-2008

Property Owner is not available for Database 'DBNAME'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

I am getting this error when trying to 'right click' a properties on the database.
Does anyone know how to fix this ?

I've tried following:

use DBNAME
EXEC sp_changedbowner 'myUser'

Getting the following message:

The proposed new database owner is already a user or aliased in the database.

Any Ideas how to fix this ?

Best Answer

myUser is probably already a database user. You shoudl be passing a login principal to the stored procedure. Do something like this:

use DBNAME
go

exec sp_changedbowner 'myLoginThatShouldBeDBO'
go

Related Solutions

Sql-server – Property PopulationStatus is not available for FullTextCatalog… How to fix

I found out that even if it is not installed it is still available on SQL Server Management Studio and you can create the indexes. It shouldn't allow...

Then I found this: SQL Server 2008 R2 Express - Installation Options, to allow FTS I need the 800MB version...

To check the status of FTS I found these queries:

SELECT
    FULLTEXTCATALOGPROPERTY(cat.name,'ItemCount'),
    FULLTEXTCATALOGPROPERTY(cat.name,'MergeStatus'),
    FULLTEXTCATALOGPROPERTY(cat.name,'PopulateCompletionAge'),
    FULLTEXTCATALOGPROPERTY(cat.name,'PopulateStatus'),
    FULLTEXTCATALOGPROPERTY(cat.name,'ImportStatus')
FROM sys.fulltext_catalogs AS cat

SELECT fulltextserviceproperty('IsFulltextInstalled')

Sql-server – SSIS error Property BackupDirectory is not available for Settings

This is a known issue with SSIS designer (although I cannot find the Connect article at this time). Most likely the backup value key in the registry is not being updated correctly with the directory for this package.

To fix this (if you are on the default instance), launch Regedit and navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer. Create a string value called "BackupDirectory" (no quotes) and in the value put the complete path of your backup directory. Then restart and your issue should be resolved.

For a named instance, the Regedit path is:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\"name of your SQL instance"\MSSQLServer

Best Answer

Related Solutions

Sql-server – Property PopulationStatus is not available for FullTextCatalog… How to fix

Sql-server – SSIS error Property BackupDirectory is not available for Settings

Related Question