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.

Thanks

On Apr 17, 2:26 pm, "akkha1...@gmail.com" <akkha1...@gmail.com> wrote:
> 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.
>
> Thanks

Are you using SQL 2k or SQL 2k5? In SQL 2005, in the New Trace dialog,
there is a "save to file" option, where you can specify the drive to
log trace data to.

Alternatively, if you're doing the trace programmatically, you can set
a param to denote location to save trace to.

Chadd

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/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Changing the location of trace file does not serve the purposes.
Changing the TMP is the answer and you have to log off and then login
to make it to be effective for profiler.
Thanks for both of you anyway for the prompt response. Now I know a
bit more about the windows environment.