How can we help you today? How can we help you today?

Why are certain tools enabling trace flag 3604?

I've noticed that certain tools such as SQL Data Compare are executing DBCC TRACEON(3604) when running.  Is this by design and if so why? I really see no reason for Data Compare to be calling this.
BrandonLeach
0

Comments

2 comments

Sort by
  • Michelle T
    Yes - it's so that the tool can get the decryption guid to decrypt encrypted objects.

    With the latest version this should only happen on SQL2008 and earlier, where we can't use a query to get the same information.

    In SQL Compare you can also disable this behaviour by deselecting the Decrypt Encrypted Objects option.
    Michelle T
    0
  • BrandonLeach
    Thank you Michelle.  I'll make sure my client updates their software. The servers in question are all SQL 2016.
    BrandonLeach
    0

Add comment

Please sign in to leave a comment.