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

SQL Server Trace

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
JohnnyBravo
0

Comments

2 comments

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0
  • JohnnyBravo
    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
    JohnnyBravo
    0

Add comment

Please sign in to leave a comment.