Database Owner

Question

Post reply

Database Owner

hawg

SSCertifiable

Points: 6044
More actions
July 11, 2003 at 10:07 am

#59289

I'm seeing something strange.
When I run the sp_helpdb stored procedure for a particular database, I see the owner as DOMAIN\username. When I look at it in EM, I see the owner as SA.
I want the owner to be SA.
Does anyone know why I am seeing this?
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Shas3 Hall of Fame Points: 3671 More actions · Answer 1

Use sp_changedbowner to change the owner of the DB and see how it shows in the EM.

Shas3

hawg SSCertifiable Points: 6044 More actions · Answer 2

I already ran the sp_changedbowner. I did this when I found the DOMAIN\username owner. I wanted it changed to SA so I ran:

exec sp_changedbowner 'sa'

When I look in EM, it is correct. When I run sp_helpdb, it still shows DOMAIN\username.

----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 3

What version and service pack for SQL Server?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

K. Brian Kelley
@kbriankelley

hawg SSCertifiable Points: 6044 More actions · Answer 4

SQL 2000 Standard Edition, SP3 (8.00.679)

----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

blakhe SSC Journeyman Points: 83 More actions · Answer 5

Just disconnect from your client and reconnect. I hv seen this happening and reconnecting will show u the new db owner (i.e. sa)

hawg SSCertifiable Points: 6044 More actions · Answer 6

Sorry but disconnecting and re-connecting was one of the first things I did. I still get the same problem.

I even tried it again today (after a weekend) and I still get the same problem.

----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

Shas3 Hall of Fame Points: 3671 More actions · Answer 7

Try the Following

1) Create a standard login

2) Use SP_changedbOwner to change owner to the standard login.

3) Check SP_HELPDB

4) Change the owner back to sa.

Shas3

hawg SSCertifiable Points: 6044 More actions · Answer 8

Weird, but it worked!

I created a new standard login, changed the owner to that then back to SA and everything shows the owner properly.

Thanks for all the responses. I know I can almost always find my answers here!

----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011