Skip to main content
S
shen1-Visitor
1-Visitor
August 12, 2019
Question

Stored Procedure has no return

  • August 12, 2019
  • 1 reply
  • 1193 views

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

V
visla14-Alexandrite
14-Alexandrite
August 13, 2019

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

Terms & ConditionsAccessibility statement