Changing the Database Owner
In Microsoft® SQL Server™ 2000, the owner of the current database can be changed. Any user (SQL Server login or Microsoft Windows NT® user) who has access to connect to SQL Server can become the owner of a database.
Ownership of the system databases (master, model, and tempdb) cannot be changed.
To change the owner of a database
Transact-SQL