NULL login name as dbo in database

Hi all!
Recently, every database i create - regardless the user -
comes with the dbo user with NULL login name.
My older databases were created correctly, with "sa" as "dbo".
I am running SQL Server 2000 SP3 on PIII 800Mhz 512MB
Tanks in advance!
DiegoYou can change database ownership to the correct owner using
sp_changedbowner:
USE MyDatabase
EXEC sp_changedbowner 'sa'
I'm not sure why new databases would get created with a NULL dbo. What
does sp_helpdb and sp_helpuser report?
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Diego Dias" <diego.dias@.terra.com.br> wrote in message
news:053601c38d11$14ed91e0$a301280a@.phx.gbl...
> Hi all!
> Recently, every database i create - regardless the user -
> comes with the dbo user with NULL login name.
> My older databases were created correctly, with "sa" as "dbo".
> I am running SQL Server 2000 SP3 on PIII 800Mhz 512MB
> Tanks in advance!
> Diego|||This occurs when you use EM and are connected with NT-authentication.
EM then shows you NT-account and when you select the ussers-tab, dbo has no
accout associatted.
(personaly, I always reroute dbo to sa, even if my developers don't like it
because they have to create tables dbo.** and have to code the 'dbo.'-part )
Jobi
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:uRT5rfUjDHA.1284@.TK2MSFTNGP09.phx.gbl...
> You can change database ownership to the correct owner using
> sp_changedbowner:
> USE MyDatabase
> EXEC sp_changedbowner 'sa'
> I'm not sure why new databases would get created with a NULL dbo. What
> does sp_helpdb and sp_helpuser report?
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> --
> SQL FAQ links (courtesy Neil Pike):
> http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> http://www.sqlserverfaq.com
> http://www.mssqlserver.com/faq
> --
> "Diego Dias" <diego.dias@.terra.com.br> wrote in message
> news:053601c38d11$14ed91e0$a301280a@.phx.gbl...
> > Hi all!
> >
> > Recently, every database i create - regardless the user -
> > comes with the dbo user with NULL login name.
> >
> > My older databases were created correctly, with "sa" as "dbo".
> >
> > I am running SQL Server 2000 SP3 on PIII 800Mhz 512MB
> >
> > Tanks in advance!
> >
> > Diego
>|||> This occurs when you use EM and are connected with NT-authentication.
> EM then shows you NT-account and when you select the ussers-tab, dbo
has no
> accout associatted.
This can be corrected with sp_changedbowner. This may occur when a
database is restored or attached but I haven't seen the problem with
CREATE DATABASE.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"jobi" <jobi@.reply2.group> wrote in message
news:bm0b8s$6q4$1@.reader08.wxs.nl...
> This occurs when you use EM and are connected with NT-authentication.
> EM then shows you NT-account and when you select the ussers-tab, dbo
has no
> accout associatted.
> (personaly, I always reroute dbo to sa, even if my developers don't
like it
> because they have to create tables dbo.** and have to code the
'dbo.'-part )
> Jobi
>
> "Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
> news:uRT5rfUjDHA.1284@.TK2MSFTNGP09.phx.gbl...
> > You can change database ownership to the correct owner using
> > sp_changedbowner:
> >
> > USE MyDatabase
> > EXEC sp_changedbowner 'sa'
> >
> > I'm not sure why new databases would get created with a NULL dbo.
What
> > does sp_helpdb and sp_helpuser report?
> >
> > --
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > --
> > SQL FAQ links (courtesy Neil Pike):
> >
> > http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> > http://www.sqlserverfaq.com
> > http://www.mssqlserver.com/faq
> > --
> >
> > "Diego Dias" <diego.dias@.terra.com.br> wrote in message
> > news:053601c38d11$14ed91e0$a301280a@.phx.gbl...
> > > Hi all!
> > >
> > > Recently, every database i create - regardless the user -
> > > comes with the dbo user with NULL login name.
> > >
> > > My older databases were created correctly, with "sa" as "dbo".
> > >
> > > I am running SQL Server 2000 SP3 on PIII 800Mhz 512MB
> > >
> > > Tanks in advance!
> > >
> > > Diego
> >
> >
>|||<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Dan and everybody that ansewered,<br>
<br>
You're all right, i was connected in EM as NT Admin account. <br>
<br>
I ran the sp_changedbowner and solved my problem.<br>
<br>
Thanks!<br>
<br>
Diego Dias<br>
Brazil<br>
<br>
Dan Guzman wrote:<br>
<blockquote type="cite"
cite="mid%23BrzYOZjDHA.4008@.TK2MSFTNGP11.phx.gbl">
<blockquote type="cite">
<pre wrap="">This occurs when you use EM and are connected with NT-authentication.
EM then shows you NT-account and when you select the ussers-tab, dbo
</pre>
</blockquote>
<pre wrap=""><!-->has no
</pre>
<blockquote type="cite">
<pre wrap="">accout associatted.
</pre>
</blockquote>
<pre wrap=""><!-->
This can be corrected with sp_changedbowner. This may occur when a
database is restored or attached but I haven't seen the problem with
CREATE DATABASE.
</pre>
</blockquote>
<br>
</body>
</html>