Apologies for the late reply,

All responses have been very informative and I'm in a better position now to start digging. I will try those scripts out this morning and...

Thanks for the reply Grant.

I was hoping to do all the investigation within SQL if possible (possibly with some type of DMV which I've overlooked) rather than sifting through the...