is it possible to change a database owner 1

[shanghai2004]

Dear Expert,

Is it possible to change a database owner to sa?
I created a new database by restoring from a database backup. The owner of the existing database is sa. But the owner of the new database is ATHENA\Administrator. (Here ATHENA is the server name). How do I make the new database to have the same owner as the database restored from?

Thanks

 

[SQLDenis]

Lookup sp_changedbowner
This worked for me

use master
go
create Database testowner
go

USE testowner
GO
EXEC sp_changedbowner 'sa'

And this will be the message

The dependent aliases were mapped to the new database owner.
Database owner changed.

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/