SQL Server Trace

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

SQL Server Trace

Postby JohnnyBravo » Tue Oct 02, 2012 9:13 pm

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
 
Posts: 2
Joined: Tue Oct 02, 2012 7:22 pm
Location: United States

Postby Brian Donahue » Wed Oct 03, 2012 9:26 am

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
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby JohnnyBravo » Wed Oct 03, 2012 5:10 pm

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
 
Posts: 2
Joined: Tue Oct 02, 2012 7:22 pm
Location: United States


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests