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