Re: database ownership changes automatically !!

From: Ron Talmage (rtalmage@prospice.com)
Date: 10/31/02 

From: "Ron Talmage" <rtalmage@prospice.com>
Date: Thu, 31 Oct 2002 10:20:02 -0800

Mahendra,

Every database is owned by some login - sa by default, but then by the
database creator's login if not sa. Inside each database, the owner is known
as 'dbo', which is just a generic alias for the database owner as a user in
the database, not the actual owner login name.

You can change the database owner using the sp_changedbowner system stored
procedure.

Ron 

--
Ron Talmage
SQL Server MVP
"Mahendra" <mahendra_Padole@ml.com> wrote in message
news:78d201c280dc$9138bb90$35ef2ecf@TKMSFTNGXA11...
> Hi ,
>
> Few days back I had created a database owner by dbo.
>
> Now today I discovered that database is owned by my NT id
> rather than dbo.  This has happed second time.
>
> Did you know this happes ? which process or activity
> changes ownerships ?
> Please help me out.
>
> Thanx,
>
> Mahendra