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

• Next in forum: How to do a Join Using Foreign Keys in Stored in a Database Column?
• Prev in forum: Re: Bulk Insert: Unexpected end-of-file (EOF) encountered...
• Thread view: Re: questions on SQL Profiler

[Reply to this message]