Stored Procedure has no return

[shen]

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

[visla]

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