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

Stored Procedure has no return

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

Re: Stored Procedure has no return

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