Sometimes you need to change the owner of a SQL Server database, perhaps as a database moves from a test environment into a production system. Using a stored procedure, the database owner can be changed, giving the new owner the permissions of the role.
...
Go to the complete details ...