Sorry for cross-post, not really sure which group is best....

Is there any way to debug and or see the temporary SPs generated by
SQL/Server?

I'm seeing many problems that can only relate to these SPs since, eg,
preparing and executing:

Call somefunc(?,?)

results in

Incorrect syntax near the keyword 'SET'

and since 'somefunc' does not include the keyword SET, Im guessing it's
SQL/Server that is the culprit.