Home Gitesh Portfolio Blog About Me Gallery Contact

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


Read/Get a SQL connection s...

Click read more to find the answer...

Editing contact us page in ...

Go to the following files abnd edit it…..
components/com_contact/views/contact/tmpl/default_address.php

Adding or assinging modules...

You can do it on SQL server...

Change database permissions...

Property Owner is not available for Database ‘[test_db]‘. This property may not exist for this object, or may...