Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2006-11-15 : 13:13:21
|
| In the sql logs i keep seeing thisDBCC TRACEON 2861 spid I keep turning this off but i see see it in the logs like 100 off lines.How is this being set ..i do not have it in the start up parametersI tried to do a trace in profiler i put in text= DBCC TRACEON (2861) but it did not work gave loads of processes |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-11-15 : 13:31:09
|
| I have seen this in connection with BMC's patrol monitoring. Do you have any monitoring software that could be touching the SQL Server? |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2006-11-15 : 14:27:24
|
| I have quest but thats turned off....Is there a way to capture in profiler ....i tried to add textand did DBCC TRACEON (2861) in query analyzer and it did not report...just reported everything else. |
|
|
|
|
|
|
SQL Log keeps reporint dbcc traceon