Timeout Problem

[rachelle]

I have written number of queries for scheduling of jobs in my database. But some of my queries give timeout. I am using SQL 2000 Server Enterprise Edition. Can someone mention the reasons for getting timeout and how to resolve the same which would help me to try out to resolve my current problem?

[ashlee]

One of the reasons for timeout is your query runs for longer time and so getting timed out. For resolving the problem of timeout you need to do proper indexing on tables which will help you to fetch results in quicker time with greater performance on database. At least check the indexes of all tables you are using the query to resolve your problem of timeout.