From: ronald@mcdonalds.com   
      
   SQL Server 2005 SP2 9.0.3054   
      
   A few times now I have had a misbehaving process that ate up way   
   too much database temp space.  I identify the process and then   
   kill the process in the Activity Monitor.   
      
   However, it doesn't release the temp space it is using.  I have   
   to restart the engine to get the temp space back.   
      
   Why would this be happening?  How can I get around this and get   
   the temp space back that a killed process was using?   
      
   thanks   
      
   aj   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)