Well all set,
Solution: EXEC sp_changedbowner 'sa'

-----Original Message-----
From: erancher1852
[mailto:mssqldba-ezmlmshield-x70735565.[Email address protected]
Sent: Friday, March 28, 2008 3:41 PM
To: LazyDBA Discussion
Subject: Re: Trouble in viewing DB property (2005)

Sounds like maybe client software issues. Try using the sp_help
commands.

On Fri, 28 Mar 2008 15:37:06 -0400, Suraparaju Vamsi wrote
> I was trying to look for the properties of database and its say's
> "can not show requested dialog (sqlMgmt)"
>
> -Property owner is not available for db [support]. This property may
> not exist for this object or may not be retrievable due to
insufficient
> access rights. (Microsoft sqlserver.smo)
>
> Well I have sql admin role on every server and I tried on different
2005
> server and I can see the properties of any database, is there
> anything where I can look.
>
> Thanks,
>
> V-
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html


--
WOW! Homepage (http://www.wowway.com)



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page