I am getting the following error every time i try to update a table on one server from data on another server "TCP Provider: The specified network name is no longer available". Here is the update statement:
set a.vendorID = b.SubID
from ana.[FleetPlus].[dbo].[ServiceHistory] as a inner join ppcor.[subcontractors].[dbo].[Subcontractors] as b
on a.vendorID = b.FleetID
It looks like you have a problem with linked server.
Do not know which one, but run these two selects and see where you have that error:
SELECT TOP 1 1 FROM ana.[FleetPlus].[dbo].[ServiceHistory]; GO SELECT TOP 1 1 FROM ppcor.[subcontractors].[dbo].[Subcontractors]; GO
Then you'd have to troubleshoot that linked server.
BTW That is extremely bad practice to link tables from different servers. That means you have to do a Full table scan on remote server, copy these data over the network, allocate memory on your SQL Server for these data and only then do a SELECT.