remote query timeout / 設在client 端
Scenario 1 – long query hit timeout error
- [on SQL_A ] : configure linked server to SQL_B
- [on SQL_A ] : change “remote query timeout” to 1 sec
- [on SQL_A ] : issue long query to select data from SQL_B
Scenario 2 – extend “remote query timeout” setting to allow long query
- [on SQL_A ] : configure linked server to SQL_B
- [on SQL_A ] : change “remote query timeout” to 900 sec
- [on SQL_A ] : issue long query to select data from SQL_B
