Prev: XP_Sendmail
Next: Server could not load dcom
From: Scott Sheen on 8 Jan 2007 22:40
MS SQL 2000.

When I attempt a SELECT I get the following:

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.

Connection Broken


The offending SELECT

select a.account
from table1 a
where a.doc = '123456A'
and (select count(1)
from table1 b
where a.account = b.account
and a.doc = b.doc
and a.oseq = b.oseq
and a.party = b.party) > 1


If I do the SELECT with out the sub select it works fine. Suggestions?

 | 
Pages: 1
Prev: XP_Sendmail
Next: Server could not load dcom