Re: SQL.LOG too big

From: Dinesh T.K (tkdinesh_at_nospam.mail.tkdinesh.com)
Date: 04/08/04


Date: Fri, 9 Apr 2004 03:12:45 +0530

Amanda,

Since Iam unable to see the original message, Iam not sure what trace you
are talking about.Anyways, check out if ODBC trace is running (run
odbcad32.exe) and check on the 'tracing' tab.If so, stop it.More info:

PRB: ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk Space
http://support.microsoft.com/default.aspx?scid=kb;en-us;268591

--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Huong" <anonymous@discussions.microsoft.com> wrote in message
news:DBF560FD-5709-496A-A51A-9396B277CA32@microsoft.com...
> Ilia,
> Were you able to delete it?  I tried to stop the trace and delete it, but
unsucessful.  It keeps saying "The process can't access the file because it
is being used by another process."
> Thanks,
> Amanda


Relevant Pages

  • Re: One Web Service updates SQL, another cant?
    ... section of the Trace Properties dialog. ... And then I start getting the database closed errors on subsequent calls. ... > The error suggests that somehow the connection to SQL Server is being ... Could we have a look at your connection string? ...
    (microsoft.public.sqlserver.security)
  • RE: cannot delete a record in sql server 2005 through asp program
    ... Using trace script he provided and trace file created by the script. ... SQL Server database by the asp application. ... Microsoft Online Community Support ... a Microsoft Support Engineer within 2 business day is acceptable. ...
    (microsoft.public.sqlserver.programming)
  • Re: Profiler Security
    ... There's no way to restrict what a user of trace can see - if they ... etc. coming into SQL Server. ... >> want to assign the developers the sys admin sql role. ...
    (microsoft.public.sqlserver.security)
  • Re: Auditing sql server at runtime
    ... "Manpreet Singh" wrote in message ... DB Dev SQL Server 2005 ... Use SQL Profiler to define your trace, ... Create a SQL Agent job to run that trace, ...
    (microsoft.public.sqlserver.clients)
  • RE: Traces for Upgrade Advisor Tool SQL Server 2005?
    ... In SQL Server 2005, global trace flags set by a session take effect in other ... SQL Server 2005 introduces global and session level trace flags. ...
    (microsoft.public.sqlserver.tools)