所以我浏览到表格,选择修改,然后添加新列.然后,当我按下保存时,我收到以下警告：
Saving Definition Changes to tables
with large amounts of data could take
a considerable amount of time. While
changes are being saved,table data
will not be accessible
我很好,数据库处于脱机状态,我一直都在这个世界上,所以我按是.
但是,操作然后在大约30秒后进行超时,并显示以下消息：
Unable to modify table. Timeout
expired. The timeout period elapsed
prior to completion of the operation
or the server is not responding.
然后,当我按OK时：
User canceled out of save dialog (MS
Visual Database Tools)
我不明白.我在SSMS连接对话框和工具 – >下都将执行超时设置为0(无限).选项 – >查询执行 – > sql Server.如果它被忽略,设置执行超时的重点是什么？
有谁知道这里使用的超时值,以及如何设置它？
解决方法
见here.
对于每个不想点击链接的人.以下是获胜的答案：
After hitting the same error,I
stumbled upon the corrent setting.In the Management Studio,from the Tools menu,select Options,then click “Designers”. There is an option called “Override connection string time-out value for table designer updates:” In the “Transaction time-out after:” Box,you will see the magic 30 seconds
