declare @name sysname

select top 1 @name=SPECIFIC_NAME from INFORMATION_SCHEMA.ROUTINES

where ROUTINE_TYPE='PROCEDURE' AND ROUTINE_SCHEMA='ABC'

while (@name is not null)

begin

execute( 'ALTER SCHEMA XYZ TRANSFER ABC.' + @name);

select top 1 @name=SPECIFIC_NAME from INFORMATION_SCHEMA.ROUTINES

where ROUTINE_TYPE='PROCEDURE' AND ROUTINE_SCHEMA='ABC'

End