T-SQL Script to change DB Owner of all databases in SQL Server

23 Oct, 2021

Below script can be used to change DB Owner details of all databases in SQL Server. This script can be modified as per owner change requirement.

declare @changedbowner varchar(255)

set @changedbowner = ''

select @changedbowner =@changedbowner +

'use [' + db.name+']; exec sp_changedbowner [' + db.name+'_dbo]'

from sys.databases db left join sys.server_principals sp

on db.owner_sid=sp.sid where database_id > 4 -- excluding system databases

print (@changedbowner) -- will display auto generated script

--exec (@changedbowner) -- will change db owner