If you want to change the dbo owner login from a database, only run this command:

ALTER AUTHORIZATION ON DATABASE::”DATABASE_NAME” TO “NEW_LOGIN”

Advertisements