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
>