Solved

dbcc traceon 2861

Posted on 2006-11-14
10
1,198 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 100 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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 400 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
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 ?
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.

733 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