change DB owners to sa
select [name] as [dbname], SUSER_SNAME([owner_sid]) AS [currentowner], N'ALTER AUTHORIZATION ON DATABASE::' + QUOTENAME([name]) + ' TO ' + QUOTENAME((SELECT [name] FROM sys.sql_logins WHERE sid = 0x01)) AS scriptoutput from sys.databases where database_id > 4 AND owner_sid <> 0x01 AND state_desc = 'ONLINE'
Comments