Great. I appreciate all yalls help. I'm a newby Db admin and this is slightly challenging. Again, thanks.

Okay, guys the creation of the 200 mb audittrace files have stopped. I guess it was the last sp_configure commands you gave me. I appreciate your...

the very large files are audittrace2009.......trc files

and they are in the data directory.

I entered them just as you gave them to me and ran them.

when I try the exec commands it tells me that I have to use sp-configure to turn it off.

when I run the sp_configure commands I receive an error message stating the 'common criteria compliance enabled' does not exist or it may be an advanced option.'

I have just restarted...

I do not know how to answer you. My original question was that these trace files are showing up without me intentionally doing anything but installing MS SQL 2005...

Sorry, I'm new to this forum and I didn't read your question clearly enough. I am running SQL server 2005 and when I run

SELECT * from sys,traces

I get...

Also I turned the cw_audit mode off yesterday. Both values are zero. It did no good. I still get huge trc files

When I run "SELECT * from fn_trace_getinfo(Default) AS FTG"

I get the following:

traceid property Value

1 ...

I am running MS SQL 2005 Standard version

They are created in

c:\program files\Microsoft SQL Server\MSSQL.1\MSSQL\Data