Comments
Sort by recent activity
I apologize, I just realized the JOIN I was trying to do actually contained an underscore (_) in the field on one table, but did not contain it on the other table. This, in addition to a case difference. Perhaps SQL Prompt already ignores case? Maybe someone can confirm this. (You know it'd be super cool if the underscore could be removed during the comparison...) / comments
I apologize, I just realized the JOIN I was trying to do actually contained an underscore (_) in the field on one table, but did not contain it on the other table. This, in addition to a case diffe...
Thanks for the clarification -- I assumed your software would need to be tested on RTM, regardless of how it worked on RC0. I will go ahead and install the current versions of your products, and see if anything doesn't work as expected.
I also experience the same frustration as jerryhung above regarding Toolbelt updates. The online Upgrade Center stopped working for me months ago, so I either have to email support (and wait a few days to hear back), or download a Toolbelt trial and get the contact from your sales department. That online Upgrade Center needs to get working again. / comments
Thanks for the clarification -- I assumed your software would need to be tested on RTM, regardless of how it worked on RC0. I will go ahead and install the current versions of your products, and se...
Tanya,
Yes, I've refreshed the cache several times. It is consistent -- I never get hints for TRUNCATE TABLE. My version of SQL Prompt is in the subject of this thread. Thanks! / comments
Tanya,
Yes, I've refreshed the cache several times. It is consistent -- I never get hints for TRUNCATE TABLE. My version of SQL Prompt is in the subject of this thread. Thanks!
I can keep databases that are running on 2005 in production at compatibility level 90. Would that help to ensure a higher success rate of comparisons? / comments
I can keep databases that are running on 2005 in production at compatibility level 90. Would that help to ensure a higher success rate of comparisons?
It smoothly progresses to 100% for the first database, then jumps down to 50% and smoothly progresses from there back to 100% for the second database. I see this behavior on every computer I've ever used: Windows XP, Windows Vista, Windows Server 2003, Windows Server 2008; in a variety of configurations, networks, and environments. I don't know what you mean by "size" of the database. The physical size ranges from 1-30 GB, while the schema could be considered "large" by some. / comments
It smoothly progresses to 100% for the first database, then jumps down to 50% and smoothly progresses from there back to 100% for the second database. I see this behavior on every computer I've eve...
I've noticed this problem for a long time as well. It would be nice to get NULL into the list of candidates. To expand upon the above post, NULL seems to never appear in the list, no matter what situation. In particular, I generally use something like this:
...
WHERE
[Field] IS NULL
And NULL is not in the candidate list. However, it does get capitalized automatically if I choose to press Space, which is NOT a completion key for me. So Prompt is recognizing it as a reserved keyword, just not as a potential candidate. This is a usability problem because if I choose to use a completion key, it will insert NULLIF() or some other (invalid) candidate. Thanks. / comments
I've noticed this problem for a long time as well. It would be nice to get NULL into the list of candidates. To expand upon the above post, NULL seems to never appear in the list, no matter what si...
Yes, Compare will compare all types of views (schemabinding or no), along with any indexes. Compare should compare every database object. Good luck with your evaluation! / comments
Yes, Compare will compare all types of views (schemabinding or no), along with any indexes. Compare should compare every database object. Good luck with your evaluation!
Tanya,
Don't you love regression issues?
A link to 3.8 would be great. I'm not using SQL 2008 yet. Could you ask the developers to put a note in the changelog for their next release to specifically mention if this issue was fixed? That way I don't upgrade again and break everything. Thanks! / comments
Tanya,
Don't you love regression issues?
A link to 3.8 would be great. I'm not using SQL 2008 yet. Could you ask the developers to put a note in the changelog for their next release to specifically...
Tanya,
Thanks for the tip on how to downgrade. Just a couple notes on what you said:
The menu path to reset the menu is not exactly what you listed. It is actually: Tools | Customize... | Select "Menubar" | Click Reset...
A lot of customers are probably using Windows Vista these days. Under that operating system, SQL Prompt saves it's files in the location: C:\Users\<username>\AppData\Local\Red Gate\SQL Prompt 3. You may want to adjust your copy/paste script there to include both locations.
According to SQL Prompt | About SQL Prompt, I'm now running version 3.8.2.402. However, both of my issues still remain: double-click selections don't work correctly, and object definition hints don't function at all, even though they are turned on. The workaround above solves the double-click issue but not the hint issue.
Thanks for your help, and I hope you guys get fixes out for this ASAP! It's amazing how much your life starts to depend on these tools -- when they go bad, it really screws up your day! / comments
Tanya,
Thanks for the tip on how to downgrade. Just a couple notes on what you said:
The menu path to reset the menu is not exactly what you listed. It is actually: Tools | Customize... | Select "...
Oops! Sorry for the false alarm. It seems that object hints are indeed working. I was hovering over a TRUNCATE TABLE statement and wasn't getting any hints. I didn't realize I wasn't supposed to get any hints there. / comments
Oops! Sorry for the false alarm. It seems that object hints are indeed working. I was hovering over a TRUNCATE TABLE statement and wasn't getting any hints. I didn't realize I wasn't supposed to ge...