Comments
Sort by recent activity
i agree there needs to be totally customisable options for:
key press automatically pops up the list (after processing the key press). Eg type a space/tab/whatever and have the list come up once the space is entered
key press to pop up tab in current position without actually inserting anything yet. for example ctrl-space should show the intellisense list, but it shouldnt insert a space like it does in the redgate version (v1.4 didnt used to insert the sapce then show the list if yo udid a ctrl-space)
what keys will select the highlighted option. In microsoft style you can press ANY key to accept, and only escape will reject. I hate having to press only TAB to accept.
We need to be able to set more than one hotkey to do any of the above actions. and also the "hotkey" shouldnt be limited to a single key, it should support ctrl, shift etc as well / comments
i agree there needs to be totally customisable options for:
key press automatically pops up the list (after processing the key press). Eg type a space/tab/whatever and have the list come up once t...
That kinda price would only be justified if the product was taken MILES ahead of where it was under Atadore and v1.4
Obviously 25 USD or whatever we paid for the v1.4 was rediculously cheap... but that is why we can easily dismiss various bugs, quirks and annoyances because hey "it didnt cost that much"
A price of $50 - $65 i would deem appropriate if it was to have the quirks/bugs fixed, some nice new functionality and a decent release cycle.
If you want top charge $95 for it then id be expecting HUGE improvements in customisiability spped and less quirkiness, total support for editing generated SQLCompare or datacompare scripts generated by other redgate tools). Especially when the release cycle will be alot less frequent than what atadore had... with other RedGate tools if there is a bug or feature annoyance that really hinders you, you have to wait months for a new release which fixes it. WIth prromptSQL atadore would fix and release things in a matter of weeks if enough people wanted/needed it! / comments
That kinda price would only be justified if the product was taken MILES ahead of where it was under Atadore and v1.4
Obviously 25 USD or whatever we paid for the v1.4 was rediculously cheap... but ...
Ditto.
I would love to see an option for us old schoolers to bring back to the toolbars. I miss my check all and uncheck all buttons. I also miss my object filter buttons, and status filter buttons [image]
I liked to be able to "turn off" showing equal items so that they werent even displayed. I know that now i can just collapse the equals section so that i dont see the objects, but i think it was better when i could choose to totally eliminate the equal objects, and the "red arrow" objects etc / comments
Ditto.
I would love to see an option for us old schoolers to bring back to the toolbars. I miss my check all and uncheck all buttons. I also miss my object filter buttons, and status filter butto...
Yeah you're really getting deep into the undocumented bits of the 32bit status field of every object in the database
essentially, calling the sp_MS_marksystemobject stored proc will do a bitwise OR of the existing status, with the value 0xC0000000 (which is 11000000000000000000000000000000)
Essentially the 2 bits that it sets to on - one is "IsSystemObject" and the other is "IsMSShipped"
The IsSystemObject is used to determine whether a table is system or user type (what you see in enterprise manager for example)
But the IsMSShipped bit is what redgate appears to use to ignore some objects (like all the guff for dt_whocheckedout and so on, that get added to database when you go to the diagram tab etc).
Basically i found that on my offending dtProperties table, the status was 1610621221 (or 01100000000000000010000100100101) and as you can see, the first bit has not been set to 1.
After running marksystem object on it, it became -536862427 (or 11100000000000000010000100100101)
Essentially you can see that
01100000000000000010000100100101
OR 11000000000000000000000000000000
= 11100000000000000010000100100101
It now has both bits set, and no longer shows up in redgate
Essentially somehow in odd circumstances, these objects that get created by going to the design tab have gotten added without the IsMSShipped bit turned on
If you want to know more about the status field and undocumented bits, this article was very helpful for me, but it seems now you have to pay to acess it whereas i dont recall that i had to pay back in april last year when i encountered this problem http://www.sqlmag.com/Articles/Index.cf ... leID=22920 / comments
Yeah you're really getting deep into the undocumented bits of the 32bit status field of every object in the database
essentially, calling the sp_MS_marksystemobject stored proc will do a bitwise OR...
I especially agree with the "highlighting the different text" comments.
it's great to now see exactly which part of an individual line are different, but as has been pointed out, without highlighting the entire line as well, you may actually miss the fact there is a difference at all
A suggestion could be that for any line that is different, highlight the ENTIRE line in a very light shade of the highlight colour, and then highlight the individual words/characters that are different as per the new V5 way (in the normal darker highlight shade) / comments
I especially agree with the "highlighting the different text" comments.
it's great to now see exactly which part of an individual line are different, but as has been pointed out, without highlighti...
I noticed a similar thing, where on the "regular" options page, if you hover over the Full Text Indexing option, the Description field explains that option, but then also has a description for "Do not include transaction plumbing"
Incidentally, what happened to the do not include transactional plumbing option? I cant find it? / comments
I noticed a similar thing, where on the "regular" options page, if you hover over the Full Text Indexing option, the Description field explains that option, but then also has a description for "Do ...
We have a similar situation here. But in my opinion it isnt necessarily RedGate's obligation to support changing windows credentials... after all - Enterprise Manager, Query Analyser and the like don't allow you to enter different windows credentials - they only operate off the currently logged on user.
If you want to run a program under different windows credentials, the "normal windows way" is to shift-right click the shortcut (or simply right click it if it's in the start menu) and choose "Run As..." This then prompts you with which windows credentials to run the aplpication under. Then when you choose windows authentication within the program, you will have the access required.
We use this for running Enterprise Manager and Query Analyser under priveledged user who can make permissions modifications etc
It can be a little annoying to always have to specify the user, so you can actually create a shortcut using the windows runas.exe
You can even have it not ask you for the password everytime, if you specify the /savecred switch (perfect for test systems)
Also note that <path_to_application> cannot contain spaces, since the entire shortcut command needs to be in quotes anyway... to get around this use the shortened DOS paths (can find these out by using dir /x )
eg to run SQLCompare as user myuser, and only supply the password the very first time, create the shortcut with
"c:\windows\system32\runas.exe /user:myuser /savecred c:\progra~1\redgat~1\sqlcompare.exe"
Hope that workaround helps you out / comments
We have a similar situation here. But in my opinion it isnt necessarily RedGate's obligation to support changing windows credentials... after all - Enterprise Manager, Query Analyser and the like ...