asked on

dbcc traceon 2861

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

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TRACEYMARY

ASKER

Nah i looked there first nothing ...
Is someone else turning it on perhaps...how else can it come on?

TRACEYMARY

ASKER

Is there a way to put this in the alert ....in sql so i can see who is turning in on

Hillwaaa

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!

TRACEYMARY

ASKER

Is this the SQLPROFILERTSQL one ?

TRACEYMARY

ASKER

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

SOLUTION

Hillwaaa

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TRACEYMARY

ASKER

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

TRACEYMARY

ASKER

its running but i get lots and lots of ...threads and the text data is blank..

TRACEYMARY

ASKER

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