trace 3604

rgfriend

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

Manfred.Castro

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