Wednesday, August 24, 2011

I got error while opening database properties






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