Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 error message on a job

Author  Topic 

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2006-03-22 : 05:51:01
i have a job runing for 40 minutes
last night after 2 years with no errors it crashed in the middle and i recived :
quote:

Executed as user: SQLPUBLIC\SqlUser1. Intra-query parallelism caused your server command (process ID #55) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1). [SQLSTATE 42000] (Error 8650) Intra-query parallelism caused your server command (process ID #55) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1). [SQLSTATE 42000] (Error 8650). The step failed.


what does this mean?

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

schuhtl
Posting Yak Master

102 Posts

Posted - 2006-03-22 : 11:37:50
See if this helps.
http://support.microsoft.com/?kbid=837983
Go to Top of Page
   

- Advertisement -