SQL Stored Procedure nocount off

[MO_10216552]

Is there any way to make a stored procedure with nocount off work in thingworx?

[jensc]

Hello,

I have created some stored procedures from thingworx, but I have never tried it using nocount.
Have you tried it in an SQL command?

If you have, what if any error messages did you receive? 

If you haven't tried yet, I would suggest you try it out.

Regards,

Jens

[Constantine]

Hello,

I have an example project which uses a whole bunch of "NOCOUNT OFF" SPs, they just work. What error do you get?

/ Constantine

[MO_10216552]

the mashups stop working

[SP_10367074]

Hello @MO_10216552 ,

Are you getting any error message in Mashup? Can you please send the Screenshot of error message if something is pop up on the mashup screen, or can you please provide me the error log to investigate more on this. 

Waiting for your kind reply. 

Regards, 

Surbhi Patel