The following error is reported when rendering reports,
Error
"Unexpected error while attempting to read from the database."
"Intra-query parallelism caused your server command (process ID #58) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1)."
SELECT [Date], [Display Name], [Physical Messages Sent], [Physical Volume Sent (KB)], [Physical Messages Received], [Physical Volume Received (KB)], [Total Physical Messages], [Total Physical Volume (KB)], [Server], [Organization], [Site/Administrative Group], [Region] FROM (SELECT * FROM V_MailboxActivity WHERE (( [Date] = (SELECT Date FROM T_MostRecentAtAGlance WHERE Source = 'Tracking Log') AND ([Server] IN (N'LATSGOEXC01V1'))))) [_IntResult] ORDER BY [Date] DESC, [Total Physical Messages] DESC, [Display Name] ASC
(0x80040217)
This only happens on multi-CPU boxes within SQL 2000
Method 4 of the following Microsoft Knowledge base article will resolve the problem.
You may receive error message 8650 when you run a query that uses intra-query parallelism http://support.microsoft.com/?kbid=837983
