When I try to run a query in Enterprise Manager (SQL Server 2000) I get a Timeout Expired message after about 20 seconds or so. I have looked in properties for the Server, for the database, and the table. Whenever I have seen a query timeout property, I have set it to 0 (which is supposed to be unlimited) - but I still get the timeout. I can run the same query in Query Analyzer and it will never timeout. I want to be able to create (and run) queries from Enterprise Manager to take advantage of the graphical interface for joining tables etc. when constructing views.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ODBC Driver Timeout expired in Enterprise Manager
- Thread starter Phil5673
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
Enterprise Manager has a builtin timeout for queries in the table vie of 20-30 seconds. This can't be modified. It's hard coded so that you don't lock up the app while wating for the query to come back.
Use Query Analyzer.
Enterprise Manager wasn't designed as a data modification tool which is why these limitations are in there.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
(Not quite so old any more.)
Use Query Analyzer.
Enterprise Manager wasn't designed as a data modification tool which is why these limitations are in there.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
(Not quite so old any more.)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question