Posted by Erland Sommarskog on 04/17/07 21:44

akkha1234@gmail.com (akkha1234@gmail.com) writes:
> I am using SQL Profiler to monitor one of my database.
> The temporary trace file is stored under C:\Documents and Settings\user
> \Local Settings\Temp
> by default. Is it possible to re-configure it to place to another
> location as the file become huge after some time.

You can change the TEMP and TMP environment variables in the System
applet in the Control Panel. (Under the Advanced tab.)


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]