Search results
3 lip 2023 · If the query doesn't return any data within the configured time-out value (typically 30 seconds), the application cancels the query and generates one of these error messages: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
14 maj 2021 · SQL Serve has a remote query timeout value that refers to its queries issued on over linked servers, not to queries issued by clients to it. I believe the query timeout is a client property, not a server property.
W interfejsie API ODBC jest on ustawiany za pomocą atrybutu SQL_ATTR_QUERY_TIMEOUT w funkcji SQLSetStmtAttr. W interfejsie API łączności z bazą danych Java (JDBC) jest on ustawiany za pomocą metody setQueryTimeout .
27 gru 2013 · Increase the Query timeout and Connection timeout values in Visual Studio using the procedures documented below. Changing the Query Timeout:
10 lut 2017 · Set the lock timeout before running the query: SET LOCK_TIMEOUT 600000 -- Wait 10 minutes max to get the lock. Do not forget to set it back afterwards to prevent subsequent queries on the connection from timing out: SET LOCK_TIMEOUT -1 -- Wait indefinitely again.
14 paź 2016 · Learn how to distinguish between connection timeout and query timeout errors in SQL Server and how to adjust them through code or connection string. See how upgrading to .NET 4.5 can help avoid query timeouts and improve performance.
8 mar 2024 · This article describes how to configure the remote query timeout server configuration option in SQL Server by using SQL Server Management Studio or Transact-SQL. The remote query timeout option specifies how long, in seconds, a remote operation can take before SQL Server times out.
