Thanks fellas I rigged up a Molex to the PCI with an adaptor I bought this morning.
However same result chaotic screen and I did remove the ATi stuff first and then installed the Nvidia drivers so looks like a dodgy GPU.
I did try the one that is working in the Ivy Bridge and try it in the Sandy but got nothing at all. I thought perhaps it might be the cable as the cable on the Ivy Bridge had the full set of pins whereas the Sandy monitor cable had the sort where the pins are divided up into little blocks - 3x3 but I then tried the same sort of cable in the Ivy and it works so don't know what went wrong there.
Anyway look thanks for all the help I shall return the faulty card asap.
Oh and Bob mate you haven't sen my room/s of gear - just can't find where I put those cables