> I realize that being the member of dbo is different than being one
> of the members of db_owner. But I'm wondering why sp_adduser
> uses is_member('dbo') rather than is_member('db_owner')?
>

<NTuser_Man@msn.com> wrote in message
news:1151466775.231563.289450@p79g2000cwp.googlegroups.com...
>I have come to find that for SQL2K the proc sp_adduser uses a
> security test is_member('dbo'), which is a different test than
> is_member('db_owner')
>
> I realize that being the member of dbo is different than being one
> of the members of db_owner. But I'm wondering why sp_adduser
> uses is_member('dbo') rather than is_member('db_owner')?
>

<NTuser_Man@msn.com> wrote in message
news:1151466775.231563.289450@p79g2000cwp.googlegroups.com...
>I have come to find that for SQL2K the proc sp_adduser uses a
> security test is_member('dbo'), which is a different test than
> is_member('db_owner')
>
> I realize that being the member of dbo is different than being one
> of the members of db_owner. But I'm wondering why sp_adduser
> uses is_member('dbo') rather than is_member('db_owner')?
>

Kalen Delaney wrote:
> In SQL 2005, it is recommended that you use CREATE USER instead of
> sp_adduser. Sp_adduser is for backward compatibility, and maybe they are
> restricting the permissions on using it to encourage people to use CREATE
> USER/CREATE SCHEMA instead.

Uri Dimant wrote:
> DBO is just a "privileged" user , that's all. BOL has pretty good
> explanation about the subject

<NTuser_Man@msn.com> wrote in message
news:1151506233.340354.191760@i40g2000cwc.googlegroups.com...
> Kalen Delaney wrote:
>> In SQL 2005, it is recommended that you use CREATE USER instead of
>> sp_adduser. Sp_adduser is for backward compatibility, and maybe they are
>> restricting the permissions on using it to encourage people to use CREATE
>> USER/CREATE SCHEMA instead.
>
>
> Uri Dimant wrote:
>> DBO is just a "privileged" user , that's all. BOL has pretty good
>> explanation about the subject
>
> Well, like I wrote my question is about the SQL2K
> the proc sp_adduser rather than a SQL2K5 proc.
>
> I realize that being the member of dbo is different
> than being one of the members of db_owner. But
> I'm wondering why sp_adduser uses is_member('dbo')
> rather than is_member('db_owner').
>
> It is pretty well documented that sp_adduser uses
> the one test and not the other. What does not
> appear to be documented is the reason why.
>

Kalen Delaney wrote:
> My apologies, I misread your question.
>
> There are many behaviors of SQL Server where MS does not document the reason
> why. I don't think this is something you should expect.