Subversion Repositories Aluchemie.virtualisatie

USE [master];
go

select [name] as [DBname],
       suser_sname([owner_sid]) as [ExistingOwner],
     N'ALTER AUTHORIZATION ON DATABASE::'
     + QUOTENAME([name]) + 'TO '
     + QUOTENAME((SELECT [name] 
                         FROM [sys].[sql_logins] 
               WHERE [sid] = 0x01
            )) AS [ScriptToChangeDBOwner]
    FROM [sys].[databases]
    WHERE [database_id] > 4
      AND [owner_sid] <> 0x01
      AND [state_desc] = 'ONLINE';

GO


use [master];
go
select [name] as [dbname], suser_sname([owner_sid]) as [dbowner] from [sys].[databases];
go