I have a scheduled task that runs and calls a remote stored procedure from with in a stored procedure. And sometimes it returns an answer in seconds, sometimes it comes back in few minutes, and sometimes it never comes back with an answer. The data that it is mostly processing the same number of records everytime. If this happenes I have to mannually kill the process in remote server than it will come back with failure message. Please let me know if anything I should try or do. Thank you