当前位置：网站首页>Sqlserver remote update timeout through linked server

Sqlserver remote update timeout through linked server

2022-07-18 10:34:00 【Song Juntao】

LAN multiple database servers access each other through linked servers , Update directly in the query editor quickly , Update through the linked server and report timeout .

Solution ：

Do not call table update directly , Call remote stored procedure update , Put the operation of updating the table on the remote server .

for example ：

update [10.x.x.x].[Test].dbo.Table set A Field =111;

Put this statement on the remote server , The outer bread is a stored procedure , By calling stored procedures remotely , The problem has to be solved .

原网站

版权声明
本文为[Song Juntao]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/199/202207152114292902.html