How can we help you today? How can we help you today?
maassql
Activity overview Badges (0) Posts (1) Comments (1)

Activity overview

Latest activity by maassql

Eddie: Sql Compare 8. Second, thank you for taking the time to cover my question. 4 YEARS!!!!! WOW how time flies. I've been using Red Gate's awesome products for almost 10 years now!!!!!! or 8 or 9 whatever. The point is, I tried looking the information up in the forum first [image] And frankly to me, it looks a whole lot like the symptoms described in a March 2005 post to which was posted by Daniel Handley: Posted: Thu Mar 10, 2005 2:24 pm Post subject: Hi Thanks for letting us know about this problem. We had already spotted this and have fixed it. The fix will appear in the next minor release of the product which will be released shortly. Regards Dan So, my questions still kinda remain from the original post - :?: What I read was SQL Compare does not know which objects are encrypted , which is not true since this info is available in objectpropertyex(sp?), and the SQL Compare already appears to ask the question at the beginning of a run - ( if there are no encrypted objects, then don't use the traceflag code route - even if that behavior is turned on ). What you were probably trying to say is that : SQL Compare has no way to find the encrypted objects within the pages on disk, so takes the approach of reading from every page in a manner which requires the use of the Trace flag. Are you telling me that's absolutely necessary? I'm no expert on internals but it seems to me that with 2005 and 2008 there was a lot more disk if not page level info given. Even if it wasn't, I doubt that the 'name' ( however it works at that level ) is encrypted. Couldn't you find some way to identify only the objects whose pages need to take the trace flag route in your code? Again, if you're asking me why this is important, see my original post, then try running SQL Compare against an instance of Microsoft Dynamics Great Plains. Once with and once without decryption set to on. And if you're gonna tell that joke "so the doctor says, Don't move your arm that way and it won't hurt", please see my third question. One of my tasks is to take snapshots of the db schema every so often and if there is no answer to my third question, it means I am damned to extremely long scripting times. :? :?: Is it possible for SQL Compare to write a message to the SQL Log / Windows App Event log saying something like "Hi, I'm such and such app and I'm doing a comparison, sorry for filling up the logs with the following messages [x, y]. Go here to learn more http://..." :?: Is the statement regarding snapshots saying that for every snapshot, the behavior "Decrypt encrypted objects on 2005 and 2008" is set to true, and that this can not be changed? If the behavior can be changed, would you please specify? / comments
  1. Community
  2. SQL Compare Previous Versions
  3. DBCC 3604 & "Decrypt encrypted objects on 2005 and 2008"
Eddie: Sql Compare 8. Second, thank you for taking the time to cover my question. 4 YEARS!!!!! WOW how time flies. I've been using Red Gate's awesome products for almost 10 years now!!!!!! or 8 or...
0 votes
DBCC 3604 & "Decrypt encrypted objects on 2005 and 2008"
  1. Community
  2. SQL Compare Previous Versions
I've read a bit about this issue here: * http://ftp.red-gate.com/messageboard/viewtopic.php?t=961&highlight=&sid=b0aa028580e878972e78492da045245d * http://ftp.red-gate.com/messageboard/viewtopic.ph...
6 followers 7 comments 0 votes
Total activity
3
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1