Danny,
In EM go to Tools->Options->Advanced Tab. Check that the Query Timeout
is set to an acceptable value - 0 means unlimited. Does that help?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html [quoted text, click to view] Danny wrote:
> Hello
> When I try to run a query from Query Analizer it work
> fine also if it employ 2:54 (174 second) for display
> result, but if I try to run the same query from SQL
> Server Enterprise Manager I have the Error Message
> "[Microsoft][ODBC SQL Server Driver] Timeout Expired".
> Way the Query work in Query Analizer and don't work in
> Enterprise Manager and in the application ?
> Best regards