[MICROSOFT SQL] – CHANGE DB OWNER

Publicado em 30 de janeiro de 2023

To change the owner of a DataBase to the following:

ALTER DATABASE DATABASE-NAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

ALTER AUTHORIZATION ON DATABASE::[DATABASE-NAME] TO [sa];
GO

ALTER DATABASE DATABASE-NAME SET MULTI_USER
GO