SQL Server connection timed out

[Prashanth Bhat]

I have stored procedure here which I am running as a scheduled task. This stored procedure in turn calls 5 other stored procedures.

The scheduled task fails and the message is "SQL Server connection timed out. (Error 10024)". How do I solve this problem?

I`ve had a similar problem to this before.

Have you tried running the stored procedure from the SQL query tool?

Do you get the same error? If not, then I would look into what other SQL processes are running at the same time as your scheduled task.

It`s a start.

Anthony B. Kenitzki



On 9/11/98 4:39:46 PM, Prashanth Bhat wrote:
> I have stored procedure here which I am running as a scheduled task. This
> stored procedure in turn calls 5 other stored procedures.

The
> scheduled task fails and the message is "SQL Server connection timed out.
> (Error 10024)". How do I solve this problem?