Mysterious DB Owner Changed

We are running a SQL 2000 server on Windows 2003 server. Somehow the db
owner changed on some of the databases. It's interesting that it changed to
the first login account listed on the server, not sure if that means anythin
g
or not. Has anyone seen the db owner mysteriously change and if so what
caused this?"Brenda" <Brenda@.discussions.microsoft.com> wrote in message
news:CAC1D3F3-225C-42AD-A992-0594561F997B@.microsoft.com...
> We are running a SQL 2000 server on Windows 2003 server. Somehow the db
> owner changed on some of the databases. It's interesting that it changed
> to
> the first login account listed on the server, not sure if that means
> anything
> or not. Has anyone seen the db owner mysteriously change and if so what
> caused this?
Did someone detach, then re-attach the databases in question using EM (as
opposed to manually executing sp_attach_db)? The attach UI allows you to
select the owner from sorted a combobox; which effectively makes the first
user the default owner. (sp_attach_db sets the owner to the current user.)
I'd think the old owner could be inferred from the orphaned dbo alias when
the db is attached, and that best-case behavior would be for previously
established ownership to be retained... but maybe not quite so simple.
In any case, sp_changedbowner is the easiest remedy.
-Mark|||Mark,
No the db's in question haven't been re-attached...I already changed the
owner, but I was just concerned that the owner changed mysteriously...Just
trying to see if anyone else has seen this happen...
Thanks!
"Mark J. McGinty" wrote:

> "Brenda" <Brenda@.discussions.microsoft.com> wrote in message
> news:CAC1D3F3-225C-42AD-A992-0594561F997B@.microsoft.com...
> Did someone detach, then re-attach the databases in question using EM (as
> opposed to manually executing sp_attach_db)? The attach UI allows you to
> select the owner from sorted a combobox; which effectively makes the first
> user the default owner. (sp_attach_db sets the owner to the current user.
)
> I'd think the old owner could be inferred from the orphaned dbo alias when
> the db is attached, and that best-case behavior would be for previously
> established ownership to be retained... but maybe not quite so simple.
> In any case, sp_changedbowner is the easiest remedy.
> -Mark
>
>|||I've never seen an unexplained database ownership change. Mark mentioned to
usual reasons. Another possibility is that a utility script was run that
changed the owners, such as one intended to correct invalid database owners
.
Hope this helps.
Dan Guzman
SQL Server MVP
"Brenda" <Brenda@.discussions.microsoft.com> wrote in message
news:CAC1D3F3-225C-42AD-A992-0594561F997B@.microsoft.com...
> We are running a SQL 2000 server on Windows 2003 server. Somehow the db
> owner changed on some of the databases. It's interesting that it changed
> to
> the first login account listed on the server, not sure if that means
> anything
> or not. Has anyone seen the db owner mysteriously change and if so what
> caused this?