MS SqlServer 2008 R2 "Query Timeout Expired"
Posted on 2013-12-10
I have a query that runs a remote machine. It queries our DB for approx 145 rows of data and when run locally in the management console on the server it takes about 45 seconds to complete. We use this for our AR statements. When I look at the Sql Server Connections property, the "Remote Query Timeout" value = 600. When I run the query from the remote server using an ODBC driver I get the following message: Sql error: ERROR [HYT00][Microsoft][Sql Server Native Client 10.0]Query timeout expired.
Any help would be appreciated.