Register   |   Login   |   February 07, 2012    |   Knowledge Base  >  Knowledge Base Systems  >  MSSQL  >  getting error in mgmt studio when opening properteries
search:     

Phone: 480-722-1227
Toll Free: 888-722-1227

getting error in mgmt studio when opening properteries
Last Post 14 Dec 2007 12:16 AM by Chris Muench. 0 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Chris MuenchUser is Offline
New Member
New Member
Posts:57

--
14 Dec 2007 12:16 AM  

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.

Active Forums 4.2
Copyright 2006 - 2011 Vigilant Support   |  Privacy Statement  |  Terms Of Use