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


Find values of QUERYSTRING ...

Click read more to view this articles...

Edit thank you message in c...

Go to: components/ com_contact/controller.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...