DDBC TraceOn

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

DDBC TraceOn

Postby cyates04 » Thu Feb 02, 2012 4:20 am

I was monitoring my prod boxes today and came across something interesting where it showed one of my developers having a DDBC TraceOn; in pulling back the app that was tied to the spid I noticed that the application was Red Gate SQL prompt......is this something when utilizing sql prompt that is done? I've heard and read on some other forums that when using the red gate sql compare utitility that this action occurs as well. Any thoughts or insight?
cyates04
 
Posts: 5
Joined: Fri Nov 04, 2011 7:58 pm
Location: Kentucky

Postby peter.peart » Fri Feb 03, 2012 12:07 pm

Thanks for your post. We do enable some trace flags, do you know which flags were being enabled?
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Postby cyates04 » Fri Feb 03, 2012 1:39 pm

The command it was running is DBCC TRACEON (3604). I do have a few additional questions if I may, the user only has data reader rights on that box; can you explain a little bit how it works behind the scenes and how it is able to turn on and off, also what are the shut off mechanisms when the tool is being used. When prompt is activated I assume by your statement that some trace flags are enabled; do they shut off once prompt is finished doing what it needs to do?
cyates04
 
Posts: 5
Joined: Fri Nov 04, 2011 7:58 pm
Location: Kentucky

Postby peter.peart » Fri Feb 03, 2012 1:55 pm

Yes, the flags go on and off, and you should be able to see this by reviewing a profiler trace.

3604 though is simply a command to output certain results to the console, i.e. SSMS, per the below link:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=134354

HTH!

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

DBCC TraceON (3604)

Postby fredmut » Tue Jan 15, 2013 5:19 pm

Can't believe this tool is flooding my SQL Server error logs with DBCC TraceON and DBCC TraceOff msgs. Is there some way to stop this from cluttering my error logs?
fredmut
 
Posts: 5
Joined: Thu Jun 21, 2012 6:12 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests