在 SQL Management Studio 中更改 CommandTimeout
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1137190/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Changing the CommandTimeout in SQL Management studio
提问by OrElse
How can I change the CommandTimeout in SQL Management Studio?
如何在 SQL Management Studio 中更改 CommandTimeout？
回答by Brian Thorne
If you are getting a timeout while on the table designer, change the "Transaction time-out after" value under Tools --> Options --> Designers --> Table and Database Designers
如果在表设计器上出现超时，请更改工具 --> 选项 --> 设计器 --> 表和数据库设计器下的“事务超时后”值
This will get rid of this message: "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
这将消除以下消息：“超时已过期。在操作完成之前超时时间已过，或者服务器没有响应。”
回答by TheVillageIdiot
Changing Command Execute Timeout in Management Studio:
在Management Studio 中更改命令执行超时：
Click on Tools -> Options
单击工具 -> 选项
Select Query Executionfrom tree on left side and enter command timeout in "Execute Timeout" control.
从左侧的树中选择查询执行并在“执行超时”控件中输入命令超时。
Changing Command Timeout in Server:
更改服务器中的命令超时：
In the object browser tree right click on the server which give you timeout and select "Properties" from context menu.
在对象浏览器树中右键单击为您提供超时的服务器，然后从上下文菜单中选择“属性”。
Now in "Server Properties -....." dialog click on "Connections" page in "Select a Page" list (on left side). On the right side you will get property
现在在“服务器属性-.....”对话框中单击“选择页面”列表（左侧）中的“连接”页面。在右侧，您将获得财产
Remote query timeout (in seconds, 0 = no timeout):
[up/down control]
you can set the value in up/down control.
您可以在上/下控制中设置该值。
回答by Jon Adams
Right click in the query pane, select Query Options...and in the Execution->General section (the default when you first open it) there is an Execution time-outsetting.
在查询窗格中右键单击，选择Query Options...并在 Execution->General 部分（第一次打开时的默认Execution time-out设置）中有一个设置。
