Red Gate forums :: View topic - DDBC TraceOn
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

DDBC TraceOn

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
cyates04



Joined: 04 Nov 2011
Posts: 5
Location: Kentucky

PostPosted: Thu Feb 02, 2012 4:20 am    Post subject: DDBC TraceOn Reply with quote

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?
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Fri Feb 03, 2012 12:07 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
cyates04



Joined: 04 Nov 2011
Posts: 5
Location: Kentucky

PostPosted: Fri Feb 03, 2012 1:39 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Fri Feb 03, 2012 1:55 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
fredmut



Joined: 21 Jun 2012
Posts: 5

PostPosted: Tue Jan 15, 2013 5:19 pm    Post subject: DBCC TraceON (3604) Reply with quote

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?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group