trace 3604

Provides intelligent code completion for SQL Server editors.

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

trace 3604

Postby rgfriend » Tue Jan 22, 2013 9:52 pm

I have a DBCC traceon (3604) and DBCC traceOff (3604)
in SQL log on my developer machine.

I did a profiler trace and found out it is from Redgate SQL Prompt 5.1.8.2.

Is that normal?

Why it needs so?

Thanks
rgfriend
 
Posts: 11
Joined: Sun Jun 12, 2011 4:46 pm

Postby Manfred.Castro » Wed Jan 23, 2013 10:34 pm

Yes this is normal.

This is done to redirect certain outputs to the client (management studio). Without that flag on, those outputs would go to the error log.

http://blogs.msdn.com/b/askjay/archive/ ... ments.aspx
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests