On 24 Jan 2002, at 20:41, Leyne, Sean wrote:

> > > Let me ask the question differently, how much free disk
> > > space _was_ on the drive.
> >
> > 295mb
> >
> > > Also, how big was the temp file?
> >
> > 211mb
>
> Odd!
>
> I would have expected the error to occur when either the sort file
> size was close to 2GB in size or to have exhausted available disk
> space.

It probably did exhaust disk space, don't forget that the swap file
is on the C drive, and that it's dynamic, so if the server uses much
working storage on the query, then it could exhaust that 295MB.

Paul
Paul Schmidt
Tricat Technologies
paul@...
www.tricattechnologies.com