| Author |
Message |
JohnnyBravo
Joined: 02 Oct 2012
Posts: 2
Location: United States
|
 Posted: Tue Oct 02, 2012 9:13 pm Post subject: 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 |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6369
Location: Red Gate Software
|
| Posted: Wed Oct 03, 2012 9:26 am Post subject: |
|
|
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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
JohnnyBravo
Joined: 02 Oct 2012
Posts: 2
Location: United States
|
| Posted: Wed Oct 03, 2012 5:10 pm Post subject: |
|
|
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 |
|
| Back to top |
|
|
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
