0

I am using R and the RODBC library to execute queries on a SQL Server database. This works fine and returns desired result sets when I execute a single select statement, or even create multiple temporary tables before selecting my final dataset.

However, when I insert the option 

OPTION (MAXDOP 1);

after my queries (which my platform administrator has asked that I use after all queries) I get the error

[RODBC] ERROR: Could not SQLExecDirect

Is there anything I can do to resolve this error while still adhering to the requirement that queries not use parallel processing?

Rookatu
  • 1,487
  • 3
  • 21
  • 50
  • Why do you want the queries to not go parallel? Let SQL Server decide what should and shouldn't go parallel. – M.Ali Aug 27 '18 at 18:14
  • @M.Ali I have no issue letting SQL Server decide, but my platform administrator has asked that I not let queries run in parallel; something to do with conserving resources or something. I'm just trying to comply with my administrator. – Rookatu Aug 27 '18 at 18:20

0 Answers0