Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

dbcc traceon 2861

Posted on 2006-11-14
10
Medium Priority
?
1,249 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 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
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
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

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.

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 ?
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

810 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