Home Forums SQL Server 2005 Administering SQL Deadlocks, can the lead to "General Network Error" messages? RE: SQL Deadlocks, can the lead to "General Network Error" messages?

  • I think I am experiencing the same issue at the minute, however I am not getting the deadlock message, just the General Network error. It happen predominately on a remote site across VPN and is intermittent, and is only caused by select queries that have a join or query with multiple result sets. Simple select queries continue to work fine and a computer restart is required to get queries running again okay. I am currently trying to add WITH (NO LOCK) to joined tables to see if it makes a difference.