Sounds to me like when SQL created it's execution plan it is running several parts of the query simultaneously. For some reason when this happens it causes a conflict within your query. What SQL is asking you to do is give it a hint about how to process the query to avoid this problem.
______________________________________________________ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com ______________________________________________________ > -----Original Message----- > From: Creese, Eric [mailto:[EMAIL PROTECTED] > Sent: Friday, July 04, 2003 1:17 PM > To: CF-Talk > Subject: Unusual SQL error > > > I never have received this error before. > > [Macromedia][SQLServer JDBC Driver][SQLServer]Intra-query > parallelism caused > your server command (process ID #52) to deadlock. Rerun the > query without > intra-query parallelism by using the query hint option (maxdop 1). > Can anyone give some insite? > > > -------------------------------------------------------------- > ---------------- > This e-mail is intended for the use of the addressee(s) only > and may contain > privileged, confidential, or proprietary information that is > exempt from > disclosure under law. If you have received this message in > error, please > inform us promptly by reply e-mail, then delete the e-mail > and destroy any > printed copy. Thank you. > ============================================================== > ================ > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
