Hi,

Eliminating Jobs from the query worked. It seems to be working quite well now. Do you know why the Jobs section caused it to fail? i am using sqlsvr2000.

I will make some modifications to this for my purpose and if it turns out well i will post my code.

Thanks for all you hard work on this