April 12, 2006 at 9:59 pm
I have SQL Server 2000 on a Windows 2000 and other SQL server 2000 on Windows 2003. They are both linked. When I try to insert rows from SQL Server on Windows 2003 into SQLServer on Windows 2000, takes too long and results in error "communication link failure" at times I have to restart both servers, I mean reboot machine. Please help me.
April 13, 2006 at 9:48 pm
My experience with this kind of data transfer is to always execute the INSERT script from the server that will be creating the rows. This tends to speed this kind of operation.
You can look at the Server settings for Remote Server Connections, Right-Click the Server in Enterprise Manager and choose the Connections tab. This setting is at the bottom of the page. Note: that the value of zero (0) turns off this kind of timeout.
Andy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply