Re: Help - 567: Cannot write sorted rows. 28: No space left o

On 26 Aug 97 at 13:54, Bill Bertovich wrote: > SELECT * FROM MyTable WHERE MyColumn = 'xxx' ORDER BY MyOtherColumn;> > Error: > 567: Cannot write sorted rows.> 28: No space left on device Uhhh, sounds like you're running out of disk space... How is your temp space set up? Can you monitor it at the time you're running the query? If you have an index on MyOtherColumn, chances are it will sort the entire table and then apply the where clause.... -- Ciao, Billy Nose to the ear in Johannesburg, Murder Capital of the World. For a good time, call: http://www.iiug.org/techinfo/faq/faq_top.html