HELP on: Intra-query parallelism caused

[drewex]

Hi i recently getting,

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

My query was running perfectly it didnt have any problems in it. Now its getting this message does any one know how to get rid of this, Ty.

[drewex]

Forgot to tell,

Microsoft has some possible solutions at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;837983

The problem i dont know what these do,

USE master
EXEC sp_configure 'show advanced option', '1'
RECONFIGURE WITH OVERRIDE
GO

EXEC sp_configure 'max degree of parallelism', 1
RECONFIGURE WITH OVERRIDE
GO

OR
DBCC TRACEON (683)

PLEASE HELP.

[drewex]

Now it stopped giving the error message. Isnt that odd, can someone tell me what could have changed, Im using sql server 7. I have to stop it happenning again. Ty