Solved

dbcc traceon 2861

Posted on 2006-11-14
10
1,172 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
  • 7
  • 2
10 Comments
 
LVL 142

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
 
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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

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 …
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

863 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now