>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%')

"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
> <kei***@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%')
>