dbo resetting

Hi!
How to reset "Login Name" from dbo user to "None" ?
Thanks!!!!Dmitry
Did you mean by sp_change_user system stored procedure?
"Dmitry Karneyev" <karneyev@.msn.com> wrote in message
news:upVTV0VxDHA.1740@.TK2MSFTNGP09.phx.gbl...
> Hi!
> How to reset "Login Name" from dbo user to "None" ?
> Thanks!!!!
>|||The login mapping for the 'dbo' user is determined by database ownership.
You can specify the desired owner with sp_changedbowner:
USE MyDatabase
EXEC sp_changedbowner 'sa'
Note that the specified login must be a valid login.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Dmitry Karneyev" <karneyev@.msn.com> wrote in message
news:upVTV0VxDHA.1740@.TK2MSFTNGP09.phx.gbl...
> Hi!
> How to reset "Login Name" from dbo user to "None" ?
> Thanks!!!!
>|||Thanks guys it helped!
But when I'm creating database in server which is only windows auth allowed
dbo user login switches to my AD account.
If server allows both types of auth then dbo login name is <None> (in
properties window in ent manager)
I changed dbo login to sa but wanted to do <None>
Any ideas?
"Dmitry Karneyev" <karneyev@.msn.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:upVTV0VxDHA.1740@.TK2MSFTNGP09.phx.gbl...
> Hi!
> How to reset "Login Name" from dbo user to "None" ?
> Thanks!!!!
>|||> But when I'm creating database in server which is only windows auth
allowed
> dbo user login switches to my AD account.
> If server allows both types of auth then dbo login name is <None> (in
> properties window in ent manager)
Are you creating a new database or attaching/restoring? In the case of a
create, I would expect the owner to be your current login, regardless of the
server authentication mode. However, the database owner following
restore/attach may not get set properly and sp_changedbowner can be used to
properly map the user.
If the 'dbo' user login shows as '<None>', this can cause problems because
SQL Server expects the login/user mapping to be properly set.
> I changed dbo login to sa but wanted to do <None>
Why do you want to do this? Is there some reason you don't want to specify
a valid login as the database owner.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Dmitry Karneyev" <karneyev@.msn.com> wrote in message
news:uqOn32WxDHA.3408@.tk2msftngp13.phx.gbl...
> Thanks guys it helped!
> But when I'm creating database in server which is only windows auth
allowed
> dbo user login switches to my AD account.
> If server allows both types of auth then dbo login name is <None> (in
> properties window in ent manager)
> I changed dbo login to sa but wanted to do <None>
> Any ideas?
> "Dmitry Karneyev" <karneyev@.msn.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:
> news:upVTV0VxDHA.1740@.TK2MSFTNGP09.phx.gbl...
> > Hi!
> > How to reset "Login Name" from dbo user to "None" ?
> >
> > Thanks!!!!
> >
> >
>|||Sorry for previous misinformation.
I guess I'm gonna understand when and why EM shows <None>.
It doesn't depent on auth mode (you are right)
It shows <None> when database creators login doesn't attached to
Security/Logins section.
Dmitry
"Dan Guzman" <danguzman@.nospam-earthlink.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:uxMOBHXxDHA.1060@.TK2MSFTNGP12.phx.gbl...
> > But when I'm creating database in server which is only windows auth
> allowed
> > dbo user login switches to my AD account.
> > If server allows both types of auth then dbo login name is <None> (in
> > properties window in ent manager)
> Are you creating a new database or attaching/restoring? In the case of a
> create, I would expect the owner to be your current login, regardless of
the
> server authentication mode. However, the database owner following
> restore/attach may not get set properly and sp_changedbowner can be used
to
> properly map the user.
> If the 'dbo' user login shows as '<None>', this can cause problems because
> SQL Server expects the login/user mapping to be properly set.
> > I changed dbo login to sa but wanted to do <None>
> Why do you want to do this? Is there some reason you don't want to
specify
> a valid login as the database owner.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
>
> "Dmitry Karneyev" <karneyev@.msn.com> wrote in message
> news:uqOn32WxDHA.3408@.tk2msftngp13.phx.gbl...
> > Thanks guys it helped!
> > But when I'm creating database in server which is only windows auth
> allowed
> > dbo user login switches to my AD account.
> > If server allows both types of auth then dbo login name is <None> (in
> > properties window in ent manager)
> >
> > I changed dbo login to sa but wanted to do <None>
> >
> > Any ideas?
> >
> > "Dmitry Karneyev" <karneyev@.msn.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
> ÓÌÅÄÕÀÝÅÅ:
> > news:upVTV0VxDHA.1740@.TK2MSFTNGP09.phx.gbl...
> > > Hi!
> > > How to reset "Login Name" from dbo user to "None" ?
> > >
> > > Thanks!!!!
> > >
> > >
> >
> >
>