Sql.log generated in C drive

[jcrivera]

Greetings...

Could anyone advise me on how to remove permanently a nasty sql.log which is generated in my C drive and increases in size when I navigate by either the Enterprise Manager and/or Query Analyzer?

I'm using NT 4.0 WS, thus I got a C: and D: drives partitioned in my PC. I installed the SQL client in the D: drive. The Sql.log was generating simultaneously in both drives and I was able to stop the one in the D: by just stopping the OLAP service.

However, the one in the C: drive is still bothering and don't know how to stop it permanently.

Help please.

Thanks.

J.C.

 

[cdukes]

The SQL.Log file is created by ODBC tracing. You will need to turn of ODBC tracing using control Panel/ODBC and turn of the tracing. You should then be able to delete the file and hopefully it should not appear again.

Hope this helps,

Chris Dukes