Posted by WCMassey on 04/17/07 21:36

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

[Back to original message]