Thanks Peso,

That works fine apart from a couple of problems

1.There's an error in the code(I managed to correct it):-

DECLARE @Schema SYSNAME,

...