Intra-query parallelism caused your server command to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).

Microsoft.SQLServer.2000.Intra_query_parallelism_caused_your_server_command_to_deadlock__Rerun_the_query_without_intra_query_parallelism_by_using_the_query_hint_option__maxdop_1 (Rule)

Knowledge Base article:

Causes

On a multiprocessor computer, SQL Server determines at execution time if the current system workload and configuration information allow for parallel query execution for a query that could benefit from a parallel plan. SQL Server re-examines the optimal number of thread decisions each time a query execution plan is retrieved from the procedure cache. For example, one execution of a query can result in use of a serial plan, a later execution of the same query can result in a parallel plan using three threads, and a third execution can result in a parallel plan using four threads.

You may see the above error if one or more of the threads used by the parallel query deadlocks on another thread within the same query. Since the number of threads used at each execution can vary, and the entire plan can change with a change in data or statistics, you may not see the error every time you execute the query.

Resolutions

Follow these steps:

Resubmit the query. A later execution may not encounter this error. If the error is received by an application, configure the application to retry one or more times when this error is encountered. For instance, from a SQL Server job, such as a replication job, you can configure the job step to retry when this error is encountered.
Force the query to only use one CPU by either setting the max degree of parallelism option server-wide with sp_configure, or use the OPTION (MAXDOP 1) query hint for this particular query. For more information about setting configuration options, see "Setting Configuration Options" in Books Online. For more information about query hints, see the "OPTION clause" section of "SELECT" in Books Online.
Rewrite the query to reduce the chance that it will deadlock on itself.
General performance tuning such as re-evaluating indexes or executing UPDATE STATISTICS can reduce the amount of time each thread needs to execute which reduces the chance of a deadlock occurring.

External

For more information about parallelism, see "Deadlocks Involving Parallelism" and "Degree of Parallelism" in Books Online and Microsoft Knowledge Base article 837983.

Element properties:

Target

Microsoft.SQLServer.2000.DBEngine

Category

EventCollection

Enabled

True

Event Source

$Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$

Alert Generate

True

Alert Severity

Warning

Alert Priority

Normal

Remotable

True

Alert Message

Intra-query parallelism caused your server command to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).

{0}

Event Log

Application

Comment

Mom2005ID='{4082770E-9E9D-40E2-A900-DA9194F9B996}'

Member Modules:

ID	Module Type	TypeId	RunAs
EventDS	DataSource	Microsoft.Windows.EventProvider	Default
GenerateAlert	WriteAction	System.Health.GenerateAlert	Default

Source Code:

<Rule ID="Microsoft.SQLServer.2000.Intra_query_parallelism_caused_your_server_command_to_deadlock__Rerun_the_query_without_intra_query_parallelism_by_using_the_query_hint_option__maxdop_1" Target="SQL2000Core!Microsoft.SQLServer.2000.DBEngine" Enabled="true" Comment="Mom2005ID='{4082770E-9E9D-40E2-A900-DA9194F9B996}'" Remotable="true">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="EventDS" TypeID="Windows!Microsoft.Windows.EventProvider">

      <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

      <LogName>Application</LogName>

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>PublisherName</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>$Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <RegExExpression>

              <ValueExpression>

                <XPathQuery>EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>MatchesMOM2005RegularExpression</Operator>

              <Pattern>^(17052|17055)$</Pattern>

            </RegExExpression>

          </Expression>

          <Expression>

            <RegExExpression>

              <ValueExpression>

                <XPathQuery>EventDescription</XPathQuery>

              </ValueExpression>

              <Operator>MatchesMOM2005BooleanRegularExpression</Operator>

              <Pattern>((^.*8650 and (not ^.*\n.*8650)) or (^.*8650.*\n.*8650)) AND (NOT ^.*[0-9]+.*8650) AND (NOT ^.*8650[0-9]+)</Pattern>

            </RegExExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="GenerateAlert" TypeID="SystemHealth!System.Health.GenerateAlert">

      <Priority>1</Priority>

      <Severity>1</Severity>

      <AlertOwner>$Data/PublisherName$</AlertOwner>

      <AlertMessageId>$MPElement[Name="Microsoft.SQLServer.2000.Intra_query_parallelism_caused_your_server_command_to_deadlock__Rerun_the_query_without_intra_query_parallelism_by_using_the_query_hint_option__maxdop_1.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

        <AlertParameter1>$Data/EventDescription$</AlertParameter1>

      </AlertParameters>

      <Suppression>

        <SuppressionValue/>

      </Suppression>

    </WriteAction>

  </WriteActions>

</Rule>