|
Home > Archive > microsoft.public.sqlserver.server > December 2002 > What is this c;\sql.log ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
What is this c;\sql.log ?
|
|
| Simon Lenn 2002-12-20, 5:23 am |
| I am running SQL Server 2000 and no other application on a windows
machine and I see many times a file c:\sql.log in the C: root
directory. This file is growing quite rapidly sometimes 200 MB plus if
I attempt to delete I get a access violation error. I start notepad
and save a empty file on sql.log to kill it. I am curious which
process is writing this file. I shutdown SQL and try deleting this
file can't delete it. Is there a utility on NT to find out what
process is accessing a file.
Thanks
Simon
| |
| Dejan Sarka 2002-12-20, 6:23 am |
| Simon,
I think you have ODBC tracing on. Check with the ODBC administration tool.
In Win 2k, go to Programs-Administrative Tools-Data Sources (ODBC) and check
the Tracing tab.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Simon Lenn" <simonlenn@yahoo.com> wrote in message
news:3641e2c2.0212200305.1e2f3199@posting.google.com...
> I am running SQL Server 2000 and no other application on a windows
> machine and I see many times a file c:\sql.log in the C: root
> directory. This file is growing quite rapidly sometimes 200 MB plus if
> I attempt to delete I get a access violation error. I start notepad
> and save a empty file on sql.log to kill it. I am curious which
> process is writing this file. I shutdown SQL and try deleting this
> file can't delete it. Is there a utility on NT to find out what
> process is accessing a file.
>
> Thanks
> Simon
| |
| Allan Mitchell 2002-12-20, 7:23 am |
| Yep I believe it is. I was asked by our Citrix Admins a while back why
these files kept appearing on the Terminal Servers and I found that it was
due to ODBC tracing
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Dejan Sarka" < dejan_please_reply_to_newsgrou
ps.sarka@reproms.si> wrote in
message news:eMrhg3BqCHA.2384@TK2MSFTNGP09...
> Simon,
>
> I think you have ODBC tracing on. Check with the ODBC administration tool.
> In Win 2k, go to Programs-Administrative Tools-Data Sources (ODBC) and
check
> the Tracing tab.
>
> --
> Dejan Sarka, SQL Server MVP
> FAQ from Neil & others at: http://www.sqlserverfaq.com
> Please reply only to the newsgroups.
> PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "Simon Lenn" <simonlenn@yahoo.com> wrote in message
> news:3641e2c2.0212200305.1e2f3199@posting.google.com...
> > I am running SQL Server 2000 and no other application on a windows
> > machine and I see many times a file c:\sql.log in the C: root
> > directory. This file is growing quite rapidly sometimes 200 MB plus if
> > I attempt to delete I get a access violation error. I start notepad
> > and save a empty file on sql.log to kill it. I am curious which
> > process is writing this file. I shutdown SQL and try deleting this
> > file can't delete it. Is there a utility on NT to find out what
> > process is accessing a file.
> >
> > Thanks
> > Simon
>
>
|
|
|
|
|