Welcome
Login  |  Register
Tuesday, January 06, 2009
  Search
You are here:Knowledge Base
 
 
 

 Please Register or login to view our private forums, it is free!!

Subject: getting error in mgmt studio when opening properteries
Prev Next
You are not authorized to post a reply.

Author Messages
cmuenchUser is Offline
Posts:59

12/13/2007 5:16 PM  

When getting the following erro use the following command to get rid of it

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

replace db_name with the name of your db

USE [db_name]

GO

EXEC sp_changedbowner 'sa'
GO

You are not authorized to post a reply.
Forums > Knowledge Base Systems > MSSQL > getting error in mgmt studio when opening properteries



ActiveForums 3.7
 
Copyright 2006-7 Vigilant Support