ALTER AUTHORIZATION ON DATABASE

declare @sql varchar (max),

@db char (30)

declare xPoz cursor local fast_forward for

select name from sysdatabases where name not in ('master','tempdb','model','msdb')

open xPoz

fetch from xPoz into @db

while @@fetch_status = 0

begin

set @sql = 'use '+rtrim(@db)+';

ALTER AUTHORIZATION ON DATABASE::['+rtrim(@db)+'] TO [sa];'

print 

@sql

fetch from xPoz into @db

end

close xPoz

deallocate xPoz