DBCC TRACE

Question

DBCC TRACE

Zeal-DBA

SSCarpal Tunnel

Points: 4332
More actions
June 22, 2010 at 7:42 am

#225888

i have turned on a trace by dbcc traceon, how wud i get the all information which is traced???

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

SQLServer-Training.com SSC Enthusiast Points: 160 More actions · Answer 1

SQL Server Error Log.....

Trace flags, after they are enabled, remain enabled in the server until disabled by executing a DBCC TRACEOFF statement.

Thanks

DBATAG

Website : http://sqlserver-training.com

Email : info@sqlServer-Training.com

Thanks
DBATAG
Website : http://sqlserver-training.com
Email : dbatag@sqlServer-Training.com

Lowell SSC Guru Points: 323518 More actions · Answer 2

are you confusing DBCC TRACEON with a system trace? (select * from sys.traces)

every DBCC TRACEON command does a different thing...some turn on something to be visible in performance counters, others format xml when the FOR XML command is used...they vary wildly and you'd need to really google each flag or read BOL for the common ones and their purpose.

you can run this command to see all the trace flags that are currently set, i believe:

DBCC TRACESTATUS();

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!