• I would like to thank Chris for this, it is excellent.

    One question I have is how do you "UNDROP" from trash can.

    Say we have 3 copies of the same table

    zz_RecycleBin.Table1_20110411_1125

    zzz_TrashCan.Table1_20110410_1426

    zzz_TrashCan.Table1_20110409_1735

    The first two we dont need to recover but we need to recover zzz_TrashCan.Table1_20110409_1735, other than scripting the table and then moving the data is there another way.

    Thanks

    Ant