When I try to access database properties in SSMS, I faced
below error.
This error looks like permission issue, but this is because
of database owner was NULL. Not sure how owner changed to NULL.
Run below query to find owner of specific database
SELECT name,
suser_sname(owner_sid) AS owner
FROM sys.databases where name = 'DBName'
Change owner of database from NULL to SA
USE DBName
EXEC sp_changedbowner 'sa'
Now you can access properties of database in SSMS
No comments:
Post a Comment