All,

Thanks for your assistance. I isolated the issue to one table. It contains over 1 million records and someone had not added the keys & indexes. Since...

Thanks for all your responses.

This issue appears to be wide spread and happening on several stored procedures. Now even my adhoc queries are taking extremely long time to return...

That did it! Thanks!! It looks like there are a few hot fixes to be rolled up into sp4. Happy Holidays.