Just to add to Aaron 's answer, this default trace is a lightweight trace
and, to avoid name confusion, it is not the blackbox trace.

The blackbox trace is heavier than the default trace and needs to be enabled
manually by using @options set to 8 (TRACE_PRODUCE_BLACKBOX) on
sp_trace_create.

Hope this s,

Ben Nevarez




"Aaron Bertrand [SQL Server MVP]" wrote:

> If this is SQL Server 2005, there is a default "black box" trace that runs
> in the background by default. Here are some blog posts about it (including
> how to turn it off, and some of the consequences of doing so):
>
> http://blogs.technet.com/vipulshah/a...rver-2005.aspx
>
> http://www.sqljunkies.com/WebLog/mz1.../09/20962.aspx
>
> http://sqlblog.com/blogs/tibor_karas...ult-trace.aspx
>
>
>
>
>
> "Donald" <donaldi@gmail.com> wrote in message
> news:OJjrJYCkIHA.4356@TK2MSFTNGP02.phx.gbl...
> > Hello everyone,
> >
> > I notice a bunch of log_nnn.trc files on my C:\Program Files\Microsoft SQL
> > Server\MSSQL.1\MSSQL\LOG folder. The file size keeps increasing.
> > However, I cannot find any instance of SQL Server Profiler is running.
> > And nobody ran profiler at all. I notice the same on other SQL Servers.
> >
> > Anyone know how these traces initiated? How to disable them?
> >
> > Thank you in advance!
> >
> > Donald
> >
>
>
>