Thank you mate for that info.. i took the lpunge and ran the insert and ... sadly i got this error
Conversion failed when converting from a character string to uniqueidentifier.
So tablediff generated this script but it wont work... any ideas?
Thanks
Antony