Ever had this?

I’ve always added a user and it’s been a real hazzle to be honest. However, I now found this little nifty script you can run instead:

ALTER AUTHORIZATION ON DATABASE::DATABASENAME TO [sa];

Tada!