• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1279
  • Last Modified:

dbcc traceon 2861

i keep seeing this in the server logs...in SQL 2000
dbcc traceon (2861) spid

I turned it off

Again i see it ....im like how is that possible if i have turned it on.

Also    dbcc traceon(208)  (can't find enough on this to turn off).

Any suggestions of how it keeps reporint in the logs
0
TRACEYMARY
Asked:
TRACEYMARY
  • 7
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
possibly it is set in the sql server startup options (check out the startup options of the server, or in the server properties)
0
 
TRACEYMARYAuthor Commented:
Nah i looked there first nothing ...
Is someone else turning it on perhaps...how else can it come on?
0
 
TRACEYMARYAuthor Commented:
Is there a way to put this in the alert ....in sql so i can see who is turning in on
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
HillwaaaCommented:
Hi TRACEYMARY,

You could use a profiler trace with TSQL options on.  You will see the dbcc traceon in the TextData column and can then get the user from the LoginName column.

Cheers!
0
 
TRACEYMARYAuthor Commented:
Is this the SQLPROFILERTSQL one ?
0
 
TRACEYMARYAuthor Commented:
I tried the trace SQLPROFILERTSQL and put in text for DBCC TRACEON (2861) but it produces lots of threads with blank in the text data...

Any ideas how to trace this.....
0
 
HillwaaaCommented:
Start up SQL Profile (from Enterprise Manager select Tools -> SQL Profiler)
Click New Trace, then enter login details for the appropriate db
If you are just happy for it to go to screen, then skip over the General tab, and on the events tab add all TSQL options
On the Data Columns tab, add all options
On the Filters tab, scroll down to "TextData" and under the "like" option write '%DBCC%'

then start the trace.

This should then list all sql commands where the dbcc command is used.

You can then see who is running DBCC TRACEON

0
 
TRACEYMARYAuthor Commented:
Ok thanks............its working now i have turned it off i see what and why its coming on

I let you know...i close for now
0
 
TRACEYMARYAuthor Commented:
its running but i get lots and lots of ...threads and the text data is blank..
0
 
TRACEYMARYAuthor Commented:
Ok...i managed to trap the condition.

It says the host is our monitoring quest software.....I go to this and its not on.
Application name SC_MSSQL

Database id = 1  (this is master)

SPID 237

So i go back to SQL Manager and look at spid 237 this is is just a normal user logging to our erp system.

Hmmm.....lost
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 7
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now