Hi All

Whenever a Cognos8 report is run one of our prod applications freezes untill I kill the spid.

I've captured a block of tsql using profiler but before I start looking through execution-plans was wondering if anyone knows a quick wins with cognos8 against sql2k in this situation?