Re: Alter User for domain user

"Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx> wrote in
news:#UC$Z$6rIHA.672@xxxxxxxxxxxxxxxxxxxx:

Is the user name a domain group instead of a user?

The user is a member of a domain, but it is not a group itself. The
user name is OurDomainName\davidw. davidw is my domain logon.

A group cannot
have a default schema.

I read that in the KB article.

Does the schema exist? You can alter the user
without the schema being created first.

Yes, the schema already exists.

Also, check out:

http://technet.microsoft.com/en-us/library/ms176060.aspx

It says that a backslash cannot be part of the user name. Perhaps you
can map the [domain\username] login to a user named [username].


The Alter User syntax worked (appeared to work) when I put brackets
around the domain\username.

I still would like for my username to have a default schema. When I
connect to the server with Windows Authentication, the default schema is
not mapped. (I used to have the dbo role, but that's not the case any
more. I know that a user with the dbo role doesn't have a default
schema.)

What can I do to beat this into submission?

Thanks.

David Walker

.