Options

SQL Server Trace

JohnnyBravoJohnnyBravo Posts: 3
edited October 3, 2012 12:10PM in SQL Compare Previous Versions
Our DBA noticed a SQL Trace was started under my account on the database and asked me about it. Since I didn't manually start one, it appears that SQL Compare 10 might have. Does SQL Compare 10 initiate a trace on the databases before running the compare, and if so, is there a way to turn this off?

Thank you very much for any info on this.

Johnny Bravo
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    SQL Compare sets a trace flag (I think it's 3604). This is to get information about the database when you first connect to it. I believe it may also set additional trace flags if you need to decrypt encrypted objects.
    · Share on Twitter
  • Options
    JohnnyBravoJohnnyBravo Posts: 3
    Thank you Brian! So this appears to be necessary part of the compare process. I just prefer to fly under the radar of DBAs. No way to run the compare without setting the trace flag, I gather.

    Thank you for the help Brian!

    Johnny Bravo
    · Share on Twitter
Sign In or Register to comment.