Posted by Erland Sommarskog on 09/21/05 00:32

Mike (mjorlando@campsystems.com) writes:
> Thanks Erland but I'm still not achieving my objective. Neither DBCC
> TRACEOFF (3226) nor DBCC TRACEOFF (3001) stops the logging. I tried it
> on the Master and the msdb databases and nothing changed. Should this
> command be run against a different database? Mike

Of course not. TRACEOFF turns off the trace flag! :-)

I didn't specify how to should activate the flag, because I was not
given any details on that. The simplest might be to add to the command
line (you can do this from Enterprise Manager), but it requires a server
restart).

I believe that DBCC TRACEON from a query window affects that process only,
nut adding -1 affects the server level. But I am very foggy on that point.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]