• 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

    Time to make a change