?
Solved

dbcc traceon 2861

Posted on 2006-11-14
10
Medium Priority
?
1,224 Views
Last Modified: 2012-06-21
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
Comment
Question by:TRACEYMARY
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 2
10 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 400 total points
ID: 17940943
possibly it is set in the sql server startup options (check out the startup options of the server, or in the server properties)
0
 
LVL 7

Author Comment

by:TRACEYMARY
ID: 17941490
Nah i looked there first nothing ...
Is someone else turning it on perhaps...how else can it come on?
0
 
LVL 7

Author Comment

by:TRACEYMARY
ID: 17941637
Is there a way to put this in the alert ....in sql so i can see who is turning in on
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 16

Expert Comment

by:Hillwaaa
ID: 17942084
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
 
LVL 7

Author Comment

by:TRACEYMARY
ID: 17948235
Is this the SQLPROFILERTSQL one ?
0
 
LVL 7

Author Comment

by:TRACEYMARY
ID: 17948656
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
 
LVL 16

Assisted Solution

by:Hillwaaa
Hillwaaa earned 1600 total points
ID: 17950922
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
 
LVL 7

Author Comment

by:TRACEYMARY
ID: 17955278
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
 
LVL 7

Author Comment

by:TRACEYMARY
ID: 17955629
its running but i get lots and lots of ...threads and the text data is blank..
0
 
LVL 7

Author Comment

by:TRACEYMARY
ID: 17956243
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

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question