To change the owner of a databaseMicrosoft® SQL Server™ allows the owner of the current database to 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.
It is not possible to change ownership of the system databases (master, model, and tempdb).
To change the owner of a database
