Para a solucionar o problema foi gerado abaixo:
declare @nome varchar(255)
declare @sql varchar(255)
declare @id varchar(10)
declare @usuario varchar(255)
declare tabs cursor for
select name,uid from sysobjects where type in ('U','V','P') and (uid<>1 AND uid<>3)
open tabs
fetch next from tabs into @nome,@id
set @usuario=(select name from sysusers where uid=@id)
while (@@fetch_status=0)
begin
set @sql='sp_changeobjectowner '+''''+@usuario+ '.' + @nome + ''',''dbo'''
EXEC(@sql)
fetch next from tabs into @nome,@id
end
close tabs
deallocate tabs