cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X

SQL Stored Procedure nocount off

MO_10216552
4-Participant

SQL Stored Procedure nocount off

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

 

4 REPLIES 4
jensc
17-Peridot
(To:MO_10216552)

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?

jensc_0-1678691743832.png

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

Hello,

 

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

 

/ Constantine

the mashups stop working

 

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  

Top Tags