First, execute that script in your query analyzer, then execute results of this query.

SELECT 'exec sp_changeobjectowner ''olduser.' + TABLE_NAME+''' , ''dbo'' ' FROM INFORMATION_SCHEMA.TABLES