From: esquel@sommarskog.se   
      
    (zmpmag3-msql@yahoo.com) writes:   
   > On Tue, 25 Jan 2011 13:09:48 +0000 (UTC), Erland Sommarskog   
    wrote:   
   >   
   >>It will probably work if you change the TEMP and TMP environment   
   >>variables for the SQL Service account. The easiest way is probably to   
   >>log into Windows as the service account for Agent, and then use Control   
   >>Panel. You probably have to restart SQL Server Agent.   
   >   
   > This seems to have been successful. The files are now re-directed to   
   > where I specified.   
      
   Looking at the screen shots you sent me, I realise that you are running   
   the Mangement Data Warehouse. It is probably not very interesting to run   
   on a development server.   
      
   When you configure the Data Collector, you are asked to specify a directory   
   for the cache files, and says that if you leave it empty it will use the   
   TEMP directory for the service account. I set up MDW and started the jobs,   
   and sure enough those .cache files started to turn up.   
      
   I guess that you once set up the MDW to see what it was, and then forgot   
   all about it. Go the Management node in Object Explorer, and select Data   
   Collector.   
      
   I have not been able to figure how you remove all the configuration,   
   but at least you can select "Stop Data Collection" from the context menu.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)