Home Gitesh Portfolio Blog About Me Gallery Contact
Kentico Certified Developer

Change database permissions if you can't open database properties

Error:

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

Solution:

use [ResearchReview-Staging]
go
execsp_changedbowner'sa'
go

Related Links:

http://databasebestpractices.com/property-owner-database/
http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/4459f608-69d4-409f-aea9-4462160f9f63/
 

Posted: 20/04/2013 11:41:33 p.m. by Gitesh Shah | with 0 comments