Issues with too many audittrace .trc files

Hi
I am running MSD 2005 Express Sequel Server and am noticing that in
the data folder located under C:\Program Files\Microsoft SQL Server
\MSSQL.1\MSSQL\Data, that every 3 hours or so a .trc file (I am
assuming it is some sort of log file) is being created. Here is a
sample title of what the file is labled:
audittrace20070618090810_328.trc. These files are big, at least
200,000KB, and are taking up way too much space in my hard drive.
Does any body here know the source for these files? What type of file
is it or neccessary for? I am assuming there is some stored process in
the sequel server that is creating these big files. I am just not sure
where to find that process or where the command is coming from.
Any help is much appreciated. Thanks in advance!
Jonathan
It is the "default trace", a Profile trace. You can turn it off using sp_configure. If you want to
check what events and columns it traces, see:
http://sqlblog.com/blogs/tibor_karaszi/archive/2007/03/12/whats-in-the-default-trace.aspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<ridingtime516@.gmail.com> wrote in message
news:1184615740.955056.40490@.o61g2000hsh.googlegro ups.com...
> Hi
> I am running MSD 2005 Express Sequel Server and am noticing that in
> the data folder located under C:\Program Files\Microsoft SQL Server
> \MSSQL.1\MSSQL\Data, that every 3 hours or so a .trc file (I am
> assuming it is some sort of log file) is being created. Here is a
> sample title of what the file is labled:
> audittrace20070618090810_328.trc. These files are big, at least
> 200,000KB, and are taking up way too much space in my hard drive.
> Does any body here know the source for these files? What type of file
> is it or neccessary for? I am assuming there is some stored process in
> the sequel server that is creating these big files. I am just not sure
> where to find that process or where the command is coming from.
> Any help is much appreciated. Thanks in advance!
> Jonathan
>