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