Re: sql2005 "Invalid Owner.."

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Bill,
Thanks for your detailed response. I am glad to hear that you had found the
resolution.
If a logon account is not a sysadmin or dbo, it is limited to modify any
properties of the database due to security factors. If you wanted to assign
more permissions or change any property of the user, you need to logon your
SQL Server with a sysadmin account. After that, please check again if the
user can view the database diagrams.

Please feel free to let me know if you have any other questions or
concerns. It is my pleasure to be of assistance.

Have a nice Christmas!

Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================



.