Hope it helps...

--- Executable scripts to change table owner

SELECT 'EXEC sp_changeobjectowner '''+ SCHEMA_NAME(schema_id) + '.' + OBJECT_NAME(object_Id) + ''', ''dbo'''FROM sys.tables

Results :

EXEC sp_changeobjectowner 'dbo.Transactions_Entry', 'dbo'

EXEC sp_changeobjectowner 'dbo.Transactions_Login', 'dbo'

EXEC sp_changeobjectowner 'dbo.Transactions_Entry_0222', 'dbo'

----------------------------------------------------------------------------------------------------------------------------------------------------

--- Executable scripts to alter schema

SELECT 'ALTER SCHEMA [test] TRANSFER ['

+ SCHEMA_NAME(schema_id) + '].[' + OBJECT_NAME(object_Id) + '];'

FROM sys.tables

Results:

ALTER SCHEMA [test] TRANSFER [dbo].[Transactions_Entry];

ALTER SCHEMA [test] TRANSFER [dbo].[Transactions_Login];

ALTER SCHEMA [test] TRANSFER [dbo].[Transactions_Entry_0222];

WHERE SCHEMA_NAME(schema_id) = 'dbo';