>When you do a SELECT... statement, where does the temporary table (name.tmp) get created (which is deleted at the end of the process) and can that location be changed?
It's speciifed by the TMPFILES setting of CONFIG.FPW. Note that it may not be created on disk. Cursors are often only in memory.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer