Link to home
Start Free TrialLog in
Avatar of ERP_TEXAS
ERP_TEXASFlag for Afghanistan

asked on

SQL Enterprise Manager (2000) times out even with Query Timeout set to 0

Queries time out after about 30 -60 seconds.

I can filter the query down and it will run.

I can run the same query in SQL Query Analyzer and it will run.

The Query timeout is set to 0. I changed it to 180 and it still times out after about 30 seconds.
Avatar of pzozulka
pzozulka

Try running sp_lock to see whats causing the timeouts.
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial