Have you lost your mind? If you've got a process sucking up more than 2gigs of temp on your PRODUCTION box and you didn't catch it while it was in dev then it's your own fault.Quote:
Originally posted by davey23uk
but if this in a a production system your useers do not want their long running queries stopping with an error.
If its not causing a problem with disk space or whatever, let it grow monitor it and fix things that cause problems
Now go sit in the corner you're in time out. :p