Comments
Sort by recent activity
So was this fix not included in build 2247? I don't seem to have auto-complete working with the same scenario - SSMS 17.2, SQL Prompt v8 build 2247, Azure AD Universal w/ MFA. / comments
So was this fix not included in build 2247? I don't seem to have auto-complete working with the same scenario - SSMS 17.2, SQL Prompt v8 build 2247, Azure AD Universal w/ MFA.
+1 to this. Not sure if it's possible, but if there are no candidates because you've typed the command out completely and it was the last entry in the list, maybe the box could go away?
e.g. I type in select * from MyDB.dbo.MyTable and do so rather quickly. By the time I get to the end of the whole statement, nothing is left except that one entry. At that point, it would be nice to just be able to bypass the autocomplete because I've done that already and there is no need to auto-complete anything.
I realize that there isn't much that can be done this time around, but wanted to add in another request for the feature. [image] / comments
+1 to this. Not sure if it's possible, but if there are no candidates because you've typed the command out completely and it was the last entry in the list, maybe the box could go away?
e.g. I typ...
I'm just curious - wasn't this part of the standard SQL Prompt package at one point and not only available in the Professional edition? I could have sworn that I could do this in an earlier release and as far as I know I've never had a "Professional" edition.
I was looking for this today as I'm laying out some new code and found all of my commas placed at the end of the line rather than at the beginning as I'd hoped for.
Thanks.
-Peter Schott / comments
I'm just curious - wasn't this part of the standard SQL Prompt package at one point and not only available in the Professional edition? I could have sworn that I could do this in an earlier releas...
Thanks, Bart. I missed that option. That should take care of that issue. Gotta love training problems. [image] / comments
Thanks, Bart. I missed that option. That should take care of that issue. Gotta love training problems.
OK. If you need someone to help test the 4.x beta, I'm more than willing to jump in. [image] / comments
OK. If you need someone to help test the 4.x beta, I'm more than willing to jump in.
Sorry, just saw the response Bart posted here: http://www.red-gate.com/MessageBoard/vi ... php?t=5590
Looking forward to the 3.6 release - this definitely slows down coding. [image]
-Pete / comments
Sorry, just saw the response Bart posted here:http://www.red-gate.com/MessageBoard/vi ... php?t=5590
Looking forward to the 3.6 release - this definitely slows down coding.
-Pete
1. SSMS - SQL 2005 SP2 + publicly released hotfix (downloaded through Windows update) - 9.00.3054
2. SQL Authentication for the most part. We have to VPN in to our data center so we don't have a trust relationship between our office and data center.
3. Production SQL Server is now 9.00.3050 (SP2 - no hotfixes).
I just downloaded the release build from your site. Just verified that it is 3.5.0.333. I was having the same issue in the 3.5 RC as well, but was hoping it would be fixed in the release.
As another note, I've found it also prompts me if I'm typing in a string (open single quote, start typing or paste in some text, get prompted to authenticate for something in the string).
Let me know what else you need and I'll send it.
-Pete / comments
1. SSMS - SQL 2005 SP2 + publicly released hotfix (downloaded through Windows update) - 9.00.3054
2. SQL Authentication for the most part. We have to VPN in to our data center so we don't have a t...
Is that next version as in 3.6 or next version as in 4.0? Just curious. I'm having a lot of trouble justifying $200 for my company to spend on the product in its current form. Getting cross-database queries back is helpful and so are the speed improvements, but it seems that a lot of items that mostly (I know and remember the bugs well :P) worked in PromptSQL were stripped away and are very slowly being added back.
Not trying to put down the team as I know coding is not an easy practice. Just saying that to me, this product is hard to justify @ $200/copy. If I were to purchase it, I'd find it much easier to pay closer to $50 and would pretty much pay out of my own pocket as I did with PromptSQL. No corporate purchasing to go through - just buy and be done.
I do appreciate the progress that 3.5 made over 3.0 and 3.1. Please don't take the above comments as if I completely dislike the product. It has a lot of use for me in day to day work.
-Pete / comments
Is that next version as in 3.6 or next version as in 4.0? Just curious. I'm having a lot of trouble justifying $200 for my company to spend on the product in its current form. Getting cross-data...
Just an FYI - still seeing this behavior. I restarted my machine, connected to a basic database, and started typing - the first time I try to use an alias for the table, I'm prompted to connect for it. Afterwards it seems to work fine.
Also, when I used the cross-database join, it worked for the most part, but I didn't get a complete listing of tables. A table called "Pledge" didn't show up in the list for some reason. I'll try to reproduce. I'd already refreshed the cache before trying that so not completely sure what was going on.
-Pete / comments
Just an FYI - still seeing this behavior. I restarted my machine, connected to a basic database, and started typing - the first time I try to use an alias for the table, I'm prompted to connect fo...
Add another issue to the list. Sometimes when I have typed in an alias for a table (same database) or had an alias chosen for the table I selected, I am prompted to connect to that alias as a database. Once I hit "Cancel" SQL Prompt works as expected, but it's kind of annoying.
I'll see if I can easily repro outside of my current query window. I know that it's happening quite a bit in this current window.
-Pete / comments
Add another issue to the list. Sometimes when I have typed in an alias for a table (same database) or had an alias chosen for the table I selected, I am prompted to connect to that alias as a data...