Query ODBC timeout

The query builder in enterprise Manager(Database,Tables,Table,Open Table,
query) is giving me a timeout ODBC error on a long query.
Is there a way to configure the query builder? I can execute the query in
Query analyzer fine.I don't believe you can change Enterprise Managers query
timeout value. The workaround is to use Query Analyzer for
those types of queries. Enterprise Manager wasn't really
designed for executing long running queries.
-Sue
On Tue, 15 Aug 2006 10:27:02 -0700, MikeChicago
<MikeChicago@.discussions.microsoft.com> wrote:
>The query builder in enterprise Manager(Database,Tables,Table,Open Table,
>query) is giving me a timeout ODBC error on a long query.
>Is there a way to configure the query builder? I can execute the query in
>Query analyzer fine.|||MikeChicago wrote:
> The query builder in enterprise Manager(Database,Tables,Table,Open Table,
> query) is giving me a timeout ODBC error on a long query.
> Is there a way to configure the query builder? I can execute the query in
> Query analyzer fine.
Don't use Enterprise Manager for running queries or otherwise
manipulating data, it's not designed for that. Use Query Analyzer.
Tracy McKibben
MCDBA
http://www.realsqlguy.com