[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

dbcc traceon 2861

Posted on 2006-11-14
10
Medium Priority
?
1,242 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
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 
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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

656 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