Hi,
Put the query into a stored proc that runs locally as an agent job and
saves the results into a table you can view anytime. When you want to
run the query, you simply start the job. That way the query run is
independent of the client connection that calls it and can run for hours
if needed.

Alternatively you can alter the "query timeout" setting in Query
Analyzer Properties or using t-sql in the query window.

Regards,
Ken


-----Original Message-----
From: Valsan, Jessy [mailto:Jessy.[Email Address Removed]
Sent: Monday, January 19, 2004 12:07 AM
To: LazyDBA.com Discussion
Subject: Query timeout


Hi,

i have a select query which joins two linked
server tables. It times out while execution.
The same one if i changed one database to local
db, it works fine.

Any clues ?

Thanks
Jessy



This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be
copied, disclosed to, retained or used by, any other party. If you are
not an intended recipient then please promptly delete this e-mail and
any attachment and all copies and inform the sender. Thank you.

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page