I am using SQL Server mgmt studio with 2005 db. I accidently clicked the
owned schemas while in a database user in security. When I went back to
remove the checkboxes they were greyed out. How do I remove them? Thanks.
DavidDavid,
You could, for instance, go to the dbo user and make it the owner of the
schema. That would take it away from the other user. (You may have a
specific user other than dbo that should be the owner.) Or, if they are not
used, get rid of the extra schemas altogether.
RLF
"David C" <dlchase@.lifetimeinc.com> wrote in message
news:%23kgXZKxGIHA.2328@.TK2MSFTNGP03.phx.gbl...
>I am using SQL Server mgmt studio with 2005 db. I accidently clicked the
>owned schemas while in a database user in security. When I went back to
>remove the checkboxes they were greyed out. How do I remove them? Thanks.
> David
>
No comments:
Post a Comment