Yeah I was going to tell you if you delete the owner and you didn't
change the owner that's the error message you get. Sorry a bit late.

PAYCHEX
Christopher Bellizzi
Information Technology * Database Administration
675 Basket Road * Webster, New York 14580
(585) 216-0670 * [Email address protected]


-----Original Message-----
From: Suraparaju Vamsi
[mailto:mssqldba-ezmlmshield-x56498681.[Email address protected]
Sent: Friday, March 28, 2008 4:04 PM
To: LazyDBA Discussion
Subject: RE: Trouble in viewing DB property (2005)

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




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




-----------------------------------------
The information contained in this message may be privileged,
confidential, and protected from disclosure. If the reader of this
message is not the intended recipient, or any employee or agent
responsible for delivering this message to the intended recipient,
you are hereby notified that any dissemination, distribution, or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately
by replying to the message and deleting it from your computer.

Thank you. Paychex, Inc.

MS Sql Server LazyDBA home page