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...

How to add a user via phpMy...

Click ReadMore to find solution...

Tips on Network Load balancing

Softwares should be same on all the servers (Also recommended to keep hardware's same)
Maximum 32 clusters supported by Microso...

Change database permissions...

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