• USE Databasename

    GO

    Exec sp_changedbowner 'new login name'