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

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

Stored Procedure has no return

shen
2-Guest

Stored Procedure has no return

Hi all,

 

i have my stored procedure runs perfectly in MSSQl, but when I create the 'SQL Query' service and execute this stored procedure, it shows 'Executing' all the time until timeout without any error. In the same Thing I have other service executes stored procedure which runs with no problem.

 

Anyone may know something?

Thank you

Regards,

SHEN

1 REPLY 1
visla
14-Alexandrite
(To:shen)

Hello @shen,

 

could you please provide the script for the SQL Query Service that is timing out? Could you please provide the script for a SQL Query Service in this same Thing that succeeds?

Please make sure you remove any confidential data before posting the scripts.

 

Thanks!

Vanessa

Top Tags