Query Timing out in Enterprise Manager

I am running Enterprise Manager in SQL Server 2000 and attempting
to do some table maintenance. When I run a delete query that should
delete approx. 600,000 rows, the query timesout and gives the following
message "[Microsoft][ODBC SQL Server Driver] Timeout expired.", but
when I run the same query using "SQL Query Analyzer" the query runs
for 4-5 minutes and finishes with no issues.
What is the difference between running the query in Query Analyzer and
Enterprise Manager?
Here is the query:
Delete from tablename
where (fieldname like '155%')
Enterprise Manager was designed as more of an admin tool,
not a client data tool. It's not meant to be used for long
running queries. Microsoft has a KB article regarding
timeouts with Enterprise Manager. The workaround is to use
Query Analyzer for long running queries:
http://support.microsoft.com/?id=247070
-Sue
On Thu, 22 Mar 2007 07:15:31 -0700, keith c
<keithc@.discussions.microsoft.com> wrote:

>I am running Enterprise Manager in SQL Server 2000 and attempting
>to do some table maintenance. When I run a delete query that should
>delete approx. 600,000 rows, the query timesout and gives the following
>message "[Microsoft][ODBC SQL Server Driver] Timeout expired.", but
>when I run the same query using "SQL Query Analyzer" the query runs
>for 4-5 minutes and finishes with no issues.
>What is the difference between running the query in Query Analyzer and
>Enterprise Manager?
>Here is the query:
> Delete from tablename
> where (fieldname like '155%')
|||rofl
WOW... I had no idea that they had a write up for that
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:msf703tleevcrihl3pfvsnljvhi5u5ac1t@.4ax.com...
> Enterprise Manager was designed as more of an admin tool,
> not a client data tool. It's not meant to be used for long
> running queries. Microsoft has a KB article regarding
> timeouts with Enterprise Manager. The workaround is to use
> Query Analyzer for long running queries:
> http://support.microsoft.com/?id=247070
> -Sue
> On Thu, 22 Mar 2007 07:15:31 -0700, keith c
> <keithc@.discussions.microsoft.com> wrote:
>