Timeout for Queries

The timeout is hard-coded to 30 seconds for queries running from the Graphical Query Designer, and you can't override the default timeout value, but you can copy the query into Query Analyzer and control the timeout setting in the Options menu.

Brian Moran

November 19, 2003

1 Min Read
ITPro Today logo in a gray background | ITPro Today

I want to run a query from Enterprise Manager, but it times out at 30 seconds, generating the following message:

SQL Server Enterprise Manager [Microsoft][ODBC SQL Server Driver]Timeout expired

I've tried to change the Query timeout option from the Tools, Options, Advanced dialog box, but the option doesn't have any effect. How can I get my query running?

I assume you're trying to run a query that you created through the Graphical Query Designer, available from the Query option on the Open Table menu within Enterprise Manager. Unfortunately, the timeout is hard-coded to 30 seconds for queries running from that interface, and you can't override the default timeout value. You can still use the Graphical Query Designer to build the query if you aren't comfortable with T-SQL, then simply copy the query into Query Analyzer to run it. You can control the query timeout setting in Query Analyzer's Options menu.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like