Thanks Steve - you confirm pretty much as I thought about TEMPDB.   As for the RAID levels I guess it's now up to me to convince the purse strings to...

Thanks guys... I intend to write a script using the TableResults option, to build a table for the purposes of producing exactly what Im after.

Thanks again.

Thanks guys, your input is much appreciated. Just to clarify, the reason for this issue arising is that we only have an absolute maximum of 15 minutes per day...

Yes, that is exactly the problem. It DROPS the Foreign Key, but never recreates it when the Table is recreated. Is this by design, or a limitation of...