Rebuild view - insufficient disk space

[Guest.Visitor]

Can anyone help Currently some of our data bases have had a lot more data added to them and consequently our rebuild of views is failing with insufficient disk space. As you can see from the message below the folder is C:WINNTTEMP - my question is can this folder be changed to a different disk ? 11/12/2006 11:11:06 PM Unable to use optimized view rebuild for view 'By Store' due to insufficient disk space at C:WINNTTEMP
otesC839B6. Need approximately 3913 MB for this view. Using standard rebuild instead. Cheers George

[David Abramowitz]

Rebuild view - insufficient disk space

Have you tried using third party software (Norton and others) to manage disk space. Windows has a tendency to produce garbage on a grand scale. Manually deleting files can be tricky, and potentially disastrous, but there is much that can be safely removed. Have software like "Clean Sweep" is a great help. Dave