GilaMonster (3/30/2011)

---

I suspect that you may need to get a specialist in (on-site) for a couple of days. I can recommend some good people here. Sounds like it's maybe too...

This is activity monitor during the time the system was unusable.

Hi, and thanks for all the replies. Yesterday was a long day and we finally got the rebuilds complete last night. I'm not happy at all with the solution, as...

Yeah I have been warned about it before, but it obviously didn't sink in. At least I will remember now that I have been burnt.

Thanks again, and good link.

Kingston, you're the man. Thanks.

SELECT ID FROM @TempTable WHERE ID IS NOT NULL works perfectly.

Cheers

Thank you. That works like the bomb.

Thanks for your reply. I am going to give it a bash now and let you know the results.