dbo > login name, it's not sa

I have a few databases on SQL2000 SP4 that are NOT owned by sa, and this
bothers me as I am trying to resolve many security issues. I've used
SP_Changedbowner and the database properties now show the owner as sa, but
when I drill into the user list under the database, the columns displayed
(Name, Login Name, Database Access) show the Name as dbo, but the Login Name
is still NOT sa. <puzzling> Does someone out there have an answer to this
for me? Can you tell me how to reset the DBO to sa, like the other 50
databases on this server'
Thank You!!!Ok, naivigate to Users (under specific database) and click refresh
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:uKHH1xlDHHA.3396@.TK2MSFTNGP02.phx.gbl...
>I have a few databases on SQL2000 SP4 that are NOT owned by sa, and this
>bothers me as I am trying to resolve many security issues. I've used
>SP_Changedbowner and the database properties now show the owner as sa, but
>when I drill into the user list under the database, the columns displayed
>(Name, Login Name, Database Access) show the Name as dbo, but the Login
>Name is still NOT sa. <puzzling> Does someone out there have an answer to
>this for me? Can you tell me how to reset the DBO to sa, like the other
>50 databases on this server'
> Thank You!!!
>|||Since you used TSQL code to change the owner, can you try looking at the
owner name using TSQL?
This code will give you the name of all your databases, and login names of
the database owners:
select name, suser_sname(sid)
from master..sysdatabases
If the code shows you the correct owner name, you are good to go.
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:uKHH1xlDHHA.3396@.TK2MSFTNGP02.phx.gbl...
>I have a few databases on SQL2000 SP4 that are NOT owned by sa, and this
>bothers me as I am trying to resolve many security issues. I've used
>SP_Changedbowner and the database properties now show the owner as sa, but
>when I drill into the user list under the database, the columns displayed
>(Name, Login Name, Database Access) show the Name as dbo, but the Login
>Name is still NOT sa. <puzzling> Does someone out there have an answer to
>this for me? Can you tell me how to reset the DBO to sa, like the other
>50 databases on this server'
> Thank You!!!
>|||Thank you, I did find that refreshing EM displayed the current owner, but
it's also nice to know the TSQL command for this... :-)
==================
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:OkLR45zDHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Since you used TSQL code to change the owner, can you try looking at the
> owner name using TSQL?
> This code will give you the name of all your databases, and login names of
> the database owners:
> select name, suser_sname(sid)
> from master..sysdatabases
> If the code shows you the correct owner name, you are good to go.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> http://sqlblog.com
>
> "WANNABE" <breichenbach AT istate DOT com> wrote in message
> news:uKHH1xlDHHA.3396@.TK2MSFTNGP02.phx.gbl...
>