Comments
Sort by recent activity
It looks like all of the config options are stored in XML files in the user's Local App Data folder. I haven't tried it, but I would imagine that you could copy those XML files and the options would all be copied.
The Local App Data folder for SQL Prompt is usually at %USERPROFILE%\Local Settings\Application Data\Red Gate\SQL Prompt 3 / comments
It looks like all of the config options are stored in XML files in the user's Local App Data folder. I haven't tried it, but I would imagine that you could copy those XML files and the options wou...
Hi, jamiet.
If you use the syntax that Tilman showed, then the candidate list should be showing up after you type the alias. If it doesn't show up for you, then I would guess you've come across a bug, as it shows up for me. However, as you said, the syntax you originally used was incorrect, so it's not really surprising that SQL Prompt wasn't able to show the candidate list, in that case.
Also, just as an FYI, you can also leave off the first FROM word. e.g.
DELETE t
FROM mytable t
WHERE t.
/ comments
Hi, jamiet.
If you use the syntax that Tilman showed, then the candidate list should be showing up after you type the alias. If it doesn't show up for you, then I would guess you've come across a ...
By not answering this question directly, and requiring it to go to a private forum such as email, it really seems like you guys have something to hide in regards to licensing. What's really odd about this is that the information IS available on the site, so I'm not sure why someone from red-gate couldn't answer it directly (Even if Tilman didn't know, couldn't someone from sales have responded?).
Anyway, jreynolds, the licensing info is at http://www.red-gate.com/products/SQL_Prompt/license.htm. I got there from the SQL Prompt product page, on the right-hand menu, there was a link for Licensing. The part that answers your question is in section 5.1. The summary is it can be used on a single computer, with a single backup copy that isn't installed on a computer. / comments
By not answering this question directly, and requiring it to go to a private forum such as email, it really seems like you guys have something to hide in regards to licensing. What's really odd ab...
Alright, thanks for letting me know. I'll keep an eye out for the first couple point releases, and will look at evaluating it again, once this is resolved.
And, it is good to know that the capitalization does still happen even if the candidate list doesn't display. However, that doesn't seem to be quite perfect, either. SQL Keywords are getting capitalized with no problems, but db objects don't get changed to match how they're actually capitalized within the db itself, unless the candidate list pops up.
When testing that, I realized that the auto-aliasing doesn't work, either, without the candidate list coming up. Plus the fact that even with the delay set lower, there are still times when I become distracted while typing it in or something and end up taking longer than the delay, and then have to deal with the same problem.
So, I really wasn't able to get it to a work in a way that was really helpful (Or at least not harmful) to my workflow. As I said, I'll keep an eye out for when this is fixed, though, and try it again.
Thanks for the response. / comments
Alright, thanks for letting me know. I'll keep an eye out for the first couple point releases, and will look at evaluating it again, once this is resolved.
And, it is good to know that the capital...