Change dbo user login

After a database move the dbo user login is orphaned from the new master
sysusers.
How can I change the dbo user login name?
TIA,
Fred
Hi Fred
Change the owner of the database with sp_changedbowner. Then the dbo user
will map to the new login.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Fred - change net to nl to email" <hfblum@.wxs.net> wrote in message
news:uNcD3E2uEHA.1312@.TK2MSFTNGP09.phx.gbl...
> After a database move the dbo user login is orphaned from the new master
> sysusers.
> How can I change the dbo user login name?
> TIA,
> Fred
>
|||The problem is not just affecting the moved database. All new databases
created have dbo with domain\administrator as login name. This NT account
has been renamed because of security issues.
How can this be corrected?
TIA,
Fred
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eOSV092uEHA.2804@.TK2MSFTNGP14.phx.gbl...
> Hi Fred
> Change the owner of the database with sp_changedbowner. Then the dbo user
> will map to the new login.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Fred - change net to nl to email" <hfblum@.wxs.net> wrote in message
> news:uNcD3E2uEHA.1312@.TK2MSFTNGP09.phx.gbl...
>
|||When created, a database is owned by the LOGIN name creating it. If your
people are login in as domain\administrator, then that will be the owner of
any databases they create.
They will either have to login using SQL Server security as 'sa', or under
some other domain name, or you will have to run sp_changedbowner.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Fred Blum" <h.f.blum@.marketconnectnospam.nl> wrote in message
news:uRiD6h$uEHA.3624@.TK2MSFTNGP09.phx.gbl...
> The problem is not just affecting the moved database. All new databases
> created have dbo with domain\administrator as login name. This NT account
> has been renamed because of security issues.
> How can this be corrected?
> TIA,
> Fred
>
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:eOSV092uEHA.2804@.TK2MSFTNGP14.phx.gbl...
>
sql