Ok that's 2 ovbious misreads... time for a break.

L8rs.

Tx for the feedback.

No offense but we all levels here ;-).

The first exemple I did was for sql server side. ...

oops :sick:

Thanks for the correction :-P.

Can you confirm that you are on SQL 7.0? (you posted on sql 2005).

I've verrrry little experience on that version and nothing to test on.

Has that package ever work?

Do you have a more complete error / log message?

stolbovoy (8/3/2011)

---

Optimizer hints is a very powerful tool and it is extremely easy to shoot yourself in a foot with. One should intimately know the data and SS before attempting...

I'd bet a lot that the...

What happens if 1 report needs to run a massive query and can only use 2 cores instead of 8 while the 6 other cores are doing nothing?

This is more...

Not clear in my mind.

I need to see a few rows of data and required output.

In the dataset and a new column. Hit expression. Then put the IIF()

Fal (8/3/2011)

---

Out of left field and most likely not related, but has anything changed on the OS/network side?

I've previously had a mysterious inexplicable slowdown only to discover a disk defrag...

Coment all the columns but one then run.

Uncomment untill you it the error. Then it'll be much easier to spot.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

ok, nothing else to offer beying what Gail already provided.