2007/04/13

[SQL] Long Running Script Timeout expired Issue

遇到資料量大(huge data)的 table 欄位變更或者是 DB Restore 時,會出現以下訊息

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.

原因為 Connection Properties / Execution Timeout 過短,請重新連線 Reconnect ,並重新設定 Execution Timeout (0=never timeout)

(如果大量作業完畢,建議可以調整回預設值)

SQL_Time_Expred_Solve

沒有留言: