Under Remote server connections, in the Remote query timeout box, type or select a value from 0 through 2,147,483,647 to set the maximum number seconds for SQL Server to wait before timing out. In Object Explorer, right-click a server and select Properties. Using SQL Server Management Studio To configure the remote query timeout option The ALTER SETTINGS permission is implicitly held by the sysadmin and serveradmin fixed server roles. To execute sp_configure with both parameters to change a configuration option or to run the RECONFIGURE statement, a user must be granted the ALTER SETTINGS server-level permission. Remote server connections must be allowed before this value can be set.Įxecute permissions on sp_configure with no parameters or with only the first parameter are granted to all users by default.To configure the remote query timeout option, using:įollow Up: After you configure the remote query timeout option This will cause any other operations to time out after the specified number of seconds.įor remote stored procedures, remote query timeout specifies the number of seconds that must elapse after sending a remote EXEC statement before the remote stored procedure times out. This value is also used to set DBPROP_GENERALTIMEOUT if supported by the remote provider. A query will wait until it completes.įor heterogeneous queries, remote query timeout specifies the number of seconds (initialized in the command object using the DBPROP_COMMANDTIMEOUT rowset property) that a remote provider should wait for result sets before the query times out. This value has no effect on queries received by the Database Engine. This value applies to an outgoing connection initiated by the Database Engine as a remote query. Setting this value to 0 disables the time-out. The default value for this option is 600, which is a 10-minute wait. The remote query timeout option specifies how long, in seconds, a remote operation can take before SQL Server times out. This topic describes how to configure the remote query timeout server configuration option in SQL Server by using SQL Server Management Studio or Transact-SQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |