A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)

with SQL Server 2005

When trying to
select col1, col2
into MyTable (on a local server)
from [developement.serverIP].devserver_DB.dbo.Base_Table

I am getting following error:

A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)

Dear experts, please advice on how to resolve this issue.
Start Free Trial