<div>
<div class="content wysiwyg-content">
I have a query that runs a remote machine. &nbsp;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. &nbsp;When I look at the Sql Server Connections property, the &quot;Remote Query Timeout&quot; value = 600. &nbsp;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.<br />
Any help would be appreciated.
</div>
</div>


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.

MS SqlServer 2008 R2 &quot;Query Timeout Expired&quot;

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

MS SqlServer 2008 R2 &quot;Query Timeout Expired&quot;

MS SqlServer 2008 R2 "Query Timeout Expired"