Mark,

How long does it take to run? You might be getting disconnected because it's taking too long. Otherwise it looks like it may just be random network failures or NIC problems either on your box or the SQL Server.

>It happens no more then once in a day, not even every day.
>Yes, I can run the SQL statement in Query Analyzer with no problem.