In a normal select into from code, I encountered the intra-query parallelism
error. This code is being executed as a stored procedure in another code tha
t
executes about 5 different sprocs. My question where does one place a query
hint to rectify this error message?
Intra-query parallelism caused your server command (process ID #69) to
deadlock. Rerun the query without intra-query parallelism by using the query
hint option (maxdop 1).You can use the MAXDOP value of 1 as a query hint- see bol for proper use.
"learningSQL" wrote:
> In a normal select into from code, I encountered the intra-query paralleli
sm
> error. This code is being executed as a stored procedure in another code t
hat
> executes about 5 different sprocs. My question where does one place a quer
y
> hint to rectify this error message?
> Intra-query parallelism caused your server command (process ID #69) to
> deadlock. Rerun the query without intra-query parallelism by using the que
ry
> hint option (maxdop 1).
Tuesday, March 27, 2012
Error 8650
Labels:
code,
database,
encountered,
error,
executed,
intra-query,
microsoft,
mysql,
oracle,
parallelismerror,
procedure,
select,
server,
sql,
stored
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment