Activity overview
Latest activity by dbbishop
I had 3 tabs open each with a connection to a different server but only had one of the servers available in the dropdown. I ultimately 'fixed' it by exciting SSMS and loading it again and connecting only to the server I wanted to search. / comments
I had 3 tabs open each with a connection to a different server but only had one of the servers available in the dropdown.I ultimately 'fixed' it by exciting SSMS and loading it again and connecting...
Changing the Server to Search
I've got several tabs open in SSMS with connections to a couple of servers. I want to do a search on one of the servers but the dropdown is only listing one server. How do I change the server that ...
Not sure where they are hiding it. I just did another download and it pulled the exact same code as was downloaded on the 10th. / comments
Not sure where they are hiding it. I just did another download and it pulled the exact same code as was downloaded on the 10th.
So, preview 2 was released almost 5 months ago and no updates. My company will not allow us to install beta/pre release software. I see a LOT of feedback from the user community about issues in the months following but Redgate is being awfully silent on the issue. How about letting us know you are still alive and well out there and hearing us? Any idea on when we will see a final stable product? / comments
So, preview 2 was released almost 5 months ago and no updates. My company will not allow us to install beta/pre release software. I see a LOT of feedback from the user community about issues in the...
I too am upset that Redgate would chose to "upgrade" a product by removing a VERY useful functionality. I don't need it often, but occasionally a Boolean search is required (I might add more so that the need for REGEX. I mean, really, add a new useful feature by removing another useful feature. Great development minds at work! PLEASE, give us back Boolean searches. / comments
I too am upset that Redgate would chose to "upgrade" a product by removing a VERY useful functionality. I don't need it often, but occasionally a Boolean search is required (I might add more so tha...
David Priddle wrote:
Hi dbbishop,
We'll have this out later this week.
Best regards,
David
Cool. I have been thinking a bit more on it. I notice that when you right-click in the SSMS query window, there are the options to run current statement or run current batch. Might be overloading to have options to "run to cursor" and "run current batch to cursor". Not sure if there are enough keys on the keyboard to include shortcuts for them using the F5 key (there is still shift-ctrl-F5. I guess there is shift-ctrl-alt-F5 :-) ). / comments
David Priddle wrote:
Hi dbbishop,
We'll have this out later this week.
Best regards,
David
Cool. I have been thinking a bit more on it. I notice that when you right-click in the SSMS query wind...
I would expect it to run from the start to the cursor, similar to "run to cursor" capability of Visual Studio. Alternately, it would run from previous 'GO' to cursor. It would be nice to have that as a configuration option, then the user could chose.
As I develop code, I build shells, and then start at the top and develop each shell. I am constantly selecting a block of code and executing it. It would be so convenient to just have the cursor at the end of the block, and press a key to say, run to here.
I may have made a change to code that loads a staging table and subsequent code processes the data in the staging table. Prior to executing the remainder of the code, I want to make sure the expected results are in the staging table, so I highlight code from the start to the end of the load of the staging table, execute it, and look at the results before continuing.
And on it goes... / comments
I would expect it to run from the start to the cursor, similar to "run to cursor" capability of Visual Studio. Alternately, it would run from previous 'GO' to cursor. It would be nice to have that ...
David,
Actually, no. If SHIFT-F5 executes the statement at the cursor, I would expect ALT-SHIFT-F% to execute from previous GO (or start of code) to the cursor, or at least have another option (CTRL-SHIFT-F5) to do that.
Most IDEs (e.g. VS) have an option to "Run to cursor".
I suppose I could simulate by adding a GO just after the block I want to execute, but heaven forbid if I forget to remove it. [image] / comments
David,
Actually, no. If SHIFT-F5 executes the statement at the cursor, I would expect ALT-SHIFT-F% to execute from previous GO (or start of code) to the cursor, or at least have another option (CTR...
CodantiM:
I believe that is the normal behavior for SQL-Prompt. It does not insert tabs, but rather spaces. I asked about this when I first purchased version 3.x and was hoping that version 4 would use tabs, but it doesn't. / comments
CodantiM:
I believe that is the normal behavior for SQL-Prompt. It does not insert tabs, but rather spaces. I asked about this when I first purchased version 3.x and was hoping that version 4 would...
I should have used formatting in the example. col2 should start in the same column as col1. / comments
I should have used formatting in the example. col2 should start in the same column as col1.