Re: DBCC TRACEON 3604

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ryan Stonecipher [MSFT] (ryanston_at_online.microsoft.com)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 09:28:12 -0700

A couple of things come to mind:

1. You can check the startup parameters in the registry of the SQL Server: HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSSQLServer/MSSQLServer/Parameters. It is possible that the trace flag is enabled there, and is turned on at startup.

2. Take a Profiler trace of the server to capture the hostname and/or application name of the client machine executing the DBCC TRACEON command.

Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine
  "Craig Brown" <craig.brown@brucepower.com> wrote in message news:296301c48e8f$17398690$a501280a@phx.gbl...
  We are operating 2 instances of SQLServer 2K SP3 which are
  reporting that SYSTEM is executing DBCC TRACEON 3604.
  I've checked on DBCC TRACEON which appears to be a
  diagnostic tool and specifically 3604 which appears to
  enable diagnostic information to be transfered to the
  client. I don't believe that the client software
  connecting to these instances are issuing the statement.
  My question is how is this statement being executed and
  how do I control it. I performed the DBCC
  TRACEON/TRACEOFF statements in Query Analyzer and the
  event viewer reports my account associated with the
  event. The other events are associated with "SYSTEM".
  Any help would be appreciated.

Relevant Pages

  • Re: question regarding bcp
    ... The command is executed on the server. ... If you want the file to be created on the client, ... > I am executing the following command from query analyzer. ... > The problem is i dont know where the output file is. ...
    (microsoft.public.sqlserver.programming)
  • Re: Regarding inetd in unix/linux
    ... problems while debugging the server. ... In our case the client will try to connect to the ... If i attach the server id to the clinet gdb session ... is not executing that script and client program is giving the errors. ...
    (comp.unix.programmer)
  • Re: Disabling objects on a web page
    ... but i need the buttons to be re-enabled once the server side code finishes executing - how can I incorporate that into client side code on a single button click? ... You can write simple client side scripts to disable the controls. ... user can't press anything else while calculations are performed. ...
    (microsoft.public.dotnet.general)
  • Re: 0xC0000005 Access Violation Help?
    ... I connect the client to the server and they talk fine until i spawn ... while the functon that is being run by the thread is executing, ... be the first suspects. ...
    (microsoft.public.dotnet.languages.vc)
  • Re: Invoking Web Service from WinForm App VERY slow first call
    ... references are still defined as web references rather that service references. ... We've narrowed it down to something that is occurring on our client ... we wrote a small console app that simply invokes the web ... Executing again produces the same results. ...
    (microsoft.public.dotnet.framework.webservices)