At 06:52 PM 26/06/2006, you wrote:

>regarding this error..
>
>CAN this be Network related ? Basically this error pops up BEFORE we
>get a network error ? Or
>is this very unlikely ?

No, it's not unlikely at all. If you always get this message in
combination with a specific network error, you're closer to
identifying the problem.

Consider if TCP/IP is not running on the client, or if a TCP/IP link
can't be established to the server for some reason, e.g. a dialup
link that was closed by a network fault; a LAN link where someone
unplugged the network cable while waiting for a response and the
server tries to respond to a client request and finds the connection
is gone. In such cases, a system error would definitely preclude any
etceteras....etc...

Another thing to look at is the disk space you are using for
temporary files. If it's c:\temp (the default, if you haven't set up
sort space purposefully) then check whether there is enough space on
the c drive to accommodate the likely size of the largest sort file
(for queries with ORDER BY, GROUP BY, DISTINCT or UNION).

./heLen