Excellent information - I've now resolved the issue.

I checked what SET commands were being issued by OSQL.EXE / ISQL.EXE prior to sending the actual query:

/*slow*/

set quoted_identifier on

set implicit_transactions off

set cursor_close_on_commit...