database owner question 2

[thamms]

Question:

When I did a restore yesterday, I was logged in as a user with sysadmin privileges. In checking the database properties today, I see that the owner is my login.

Should I change this to sa?

Thanks

 

[drtree]

Hey,

I would change it. Just use the sp_changedbowner sproc (check out this page for some info:

http://msdn2.microsoft.com/en-us/library/aa259622(SQL.80).aspx)

Doc Tree

 

[mrdenny]

You can set the owner to sa if you would like. There is no need to change the account.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[tadd]

Is there ever any risk in changing the database owner to 'sa' ???

Just wondering...

 

[SQLBill]

Yes, but this is rare. Some vendor created databases require a specific database owner, ususually set when their application/software creates the database.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875