Hi,

You can change object owner in a streatch with the following command if you are having more no of tables to change object owner.

select 'execute sp_changeobject owner '+ '''' + 'xyz.'+name+''' '+','+'''dbo''' from sysobjects where xtype = 'U' and uid=5 order by name