Cause
=====
for this errors two reasons
1)one is Database Owner is null
2)Original DBO Login was removed recently
Resolution
----------
first i checked the database owners
this is for all db's in a instace
-----------------------------
SELECT name,SUSER_SNAME(owner_sid) as DB_Owner
FROM sys.databases
out put
--------
I found probably Database Owner is NUll..
Then i changed Database Owner to SA
USE DB_Name
go
EXEC sp_changedbowner 'sa'
after that i am able to open the Database Properties
No comments:
Post a Comment