Comments
Sort by recent activity
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...
I will need to see if I can re-create the problem. It happened after I used SSMS against a SQL 2000 SP4 server to Modify a proc, then copied part of that proc, selected everything, and pasted my section over the whole (I just needed to use that section of code for some custom work). After that, every time I aliased something it would prompt for a connection the first time I tried to use it and afterwards it would work as expected. If I can reproduce it I will definitely send it back.
The aliases were pretty short - a, ad, ip, ss - none of these overlapped an existing DB or linked server.
I'm logged in as a SQL Login, member of SysAdmin, but not "sa".
We have ~10-15 DB's on the server.
-Pete / comments
I will need to see if I can re-create the problem. It happened after I used SSMS against a SQL 2000 SP4 server to Modify a proc, then copied part of that proc, selected everything, and pasted my s...
Looks like the 3.5 RC made some significant headway for me. You may want to give it a try.
-Pete / comments
Looks like the 3.5 RC made some significant headway for me. You may want to give it a try.
-Pete
Also - quick note for those mentioning the VM thing. MS offers up Virtual Server (and I think Virtual PC) free of charge. VMWare has a free version of their server product. While neither are extremely full-featured, you can easily download and install them and set up a new OS. You can even do some basic snapshots/differences on your virtual hard drive for an easy restore to state (like before you installed Katmai so you can restore the snapshot and have a clean system without messing around with uninstalls that may or may not work [image] )
-Pete / comments
Also - quick note for those mentioning the VM thing. MS offers up Virtual Server (and I think Virtual PC) free of charge. VMWare has a free version of their server product. While neither are ext...
For those of us who do have VMs into which we've installed Katmai, what are the licensing concerns for SQL Prompt? Can we install into the VM because it's still on our local box? Do we need a new copy? Just install an unregistered version? I'd like to play around with that some, but will not bother if I have to buy a version just to test with and I don't want to ding any sort of activation counts I may have on my account for a test instance either. Testing is nice, but I'll live without it if it affects my account.
Thanks.
-Pete / comments
For those of us who do have VMs into which we've installed Katmai, what are the licensing concerns for SQL Prompt? Can we install into the VM because it's still on our local box? Do we need a new...
Not sure how it works in your mode, but I set up snippets for my use and am able to type the snippet, then hit enter or tab (or sometimes even a period) and it puts in the code. My biggest problem is that it seems to do this too quickly most of the time. e.g. I've aliased one of my tables with an "i", but it's not in the current database. When I later try to type "i." + ColumnName, I often get INFORMATION_SCHEMA() popping up before I can blink. Undo, repeat, undo, repeat again, undo, type really quickly or hit ESC to stop the popup. :P
-Pete / comments
Not sure how it works in your mode, but I set up snippets for my use and am able to type the snippet, then hit enter or tab (or sometimes even a period) and it puts in the code. My biggest problem...