Sql.log???

[Per F Jonsson]

Hello

I惴 a beginner working with sql-server.

I have Backoffice with SQL-sever 7 installed.

My problem is that everytime I start the Enterprise Manager every task I
want to do (just a click on a database or so) will take several seconds to
do, sometimes up to a couple of minutes. The only way to overcome this
problem is to restart the sql-server. Then it runs smoothly until next time
I enter the Enterprise Manager.
Is there anyway to solve this problem?

I have also noticed that the file sql.log in the c-root expands all the
time. I don愒 know what that file does, it contains some kind of log that
I惴 unable to understand. When I look in another server that also runs
sql-server i noticed that the file sql.log doesn愒 exist at all!
Because of the size of the sql.log-file (200 MB) I was forced to delete it
yesterday but the server created it again, and now it愀 growing again!.
How can I stop this logging?

Please help me!

Best regards

Per F Jonsson
p...@perlin.nu
www.perlin.nu
Sweden

[Neil Pike]

Per,

> Subject: Sql.log???

Q. Why have I got a large file called SQL.LOG that I can't delete?
(v1.0 1999.07.27)

A. This is the default name for the ODBC trace file - it defaults to the root
of the C drive but can be moved or renamed.

Go to control panel/odbc (called data access components on W2K or latest
MDAC's). Check the tracing option here and turn it off. You should then be
able to delete the file.

Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
SQL FAQ (344 entries) see
sqlfaq.zip in lib 1 @ http://go.compuserve.com/sqlserver
or www.ntfaq.com/sql.html (+ ntfaq download)
or http://www.swynk.com/faq/sql/sqlserverfaq.asp
or http://www.sql-server.co.uk