I ran the firmware updates and the proliant support pack updates, and ran the MS hotfix and so far i am looking ok. This weeks index rebuild went ok....

I again continued with your advice and contacted HP about the server. I found out that the quad core CPU has know issues with certain RAID controllers. During...

Taking your advice I looked on the HP web site and found both a firmware update dated 10 february 2009 and a drivers (support pack) update for 30 march 2009....

First, thank you very much for your help

I am going to take the advice of both replys and more specifically I will download the latest driver pack for the server...

Over the weekend i did not run the Remote Report Server and everything was back to normal. I am not sure why this would cause a problem, but i...

When you say the DB crashed, can we get a little more detail on what you mean? (log filled up the disk drive, server froze, etc).

I arrive at the office...

Thank You

It worked perfectly and since i have to run this for several buildings it saves me lots of time.

Thanks again

Yes i am running steve's code and still i get 2251 records.

I examined the result and the code is picking up all possible matching suitid so I am...

I am getting a result of 2951 records.

The leas table has 321

THE SUIT TABLE HAS 314

Not sure why i am not getting the result i need. ...

Thanks. Cannot believe that i could not figure it out. It was simple and I tried very hard.

Thanks Again

I was on the edge of my seat. Good thing it was fake