Comments
Sort by recent activity
Besides it causing a SP to be recompiled every time it is run, do you know why it is considered "evil"?
Consider this a feature request to add SELECT INTO support sometime in the future. [image] / comments
Besides it causing a SP to be recompiled every time it is run, do you know why it is considered "evil"?
Consider this a feature request to add SELECT INTO support sometime in the future.
Yeah, that wasn't the real INSERT statement, but it was a sanitized one that I could share.
Changing that options appears to have solved the problem, though I change it to 250, since we deal with a lot of large statements.
Thanks! / comments
Yeah, that wasn't the real INSERT statement, but it was a sanitized one that I could share.
Changing that options appears to have solved the problem, though I change it to 250, since we deal with a...
I don't have any problems like that, but I don't have <space> configured as a completion key because it would cause all kinds of problems like this. When I type is it shows me the INFORMATION_SCHEMA snippet, but I don't hit a completion key to trigger it.
I suspect if you remove <space> as a completion key you will be happier with how things work, you just have to get used to using a different completion key. (I only use <.> and <tab> as completion keys.)
Of course the other option would be to edit or delete some of the snippets to better fit your needs. / comments
I don't have any problems like that, but I don't have <space> configured as a completion key because it would cause all kinds of problems like this. When I type is it shows me the INFORMATION_SCHE...
OK, I installed the 3.6 EA, and things are better, SQL Prompt is working again for me, and I can keep most of my custom settings across logons. (I have found that I can never 'upgrade' I have to uninstall the old version, and then install the new version to get it to work.)
What I have found now is that SQL Prompt still creates these files:
CompletionConfiguration.xml
Permissions_Sql2005.xml
SecurableClasses_Sql2005.xml
Permissions_Sql2000.xml
SecurableClasses_Sql2000.xml
in this directory: "C:\Documents and Settings\<username>\Local Settings\Application Data\Red Gate\SQL Prompt 3"
All that means is that the files are lost every time we log off, and get re-created every time we logon and start SQL Prompt. (Of course that means we can't customize the CompletionConfiguration.xml file.)
This is a great step in the right direction, though it would be nice if there was a registry setting that could redirect all of the files out of the "local settings" directory to one place. (Maybe an option to just remove "Local Settings\" from all option/configuration file paths?)
Thanks! / comments
OK, I installed the 3.6 EA, and things are better, SQL Prompt is working again for me, and I can keep most of my custom settings across logons. (I have found that I can never 'upgrade' I have to un...
The directory I set it to does exist, the problem is that the location for the "CompletionConfiguration.xml" file isn't getting redirected to a spot other than default, even with me setting all three of the keys you mentioned.
The default directory does get created if I don't redirect it, so "CompletionConfiguration.xml" gets created.
Once I redirect the main configuration files, so that the options aren't lost every time we log off, the default directory doesn't get created, so SQL Prompt fails trying to create "CompletionConfiguration.xml" every time.
Any idea when a version would be available that can be used with roaming profiles? (It is getting really old to loose all of our settings every time we have to log off the PC.) / comments
The directory I set it to does exist, the problem is that the location for the "CompletionConfiguration.xml" file isn't getting redirected to a spot other than default, even with me setting all thr...
If you're not careful we will take two miles. :lol:
Is there a procedure for making an official feature request? (Given what you have already, I suspect that expanding it would be fairly easy.)
In any case, I am glad that the next version takes a step in the correct direction.
Thanks! / comments
If you're not careful we will take two miles. :lol:
Is there a procedure for making an official feature request? (Given what you have already, I suspect that expanding it would be fairly easy.)
In...
Will those registry entries expand variables, so that something like:
C:\Documents And Settings\%username%\Application Data\RedGate\SQLPrompt
could be used, and would get expanded correctly for the user?
Even better would be to have the settings first come from the Policy registry section, HKLM\Software\Policies and/or HKCU\Software\Policies, so that a GP could be deployed to control the location. / comments
Will those registry entries expand variables, so that something like:
C:\Documents And Settings\%username%\Application Data\RedGate\SQLPrompt
could be used, and would get expanded correctly for the...
Aaron,
Thank you very much for the quick fix, it does indeed fix the problem for me. / comments
Aaron,
Thank you very much for the quick fix, it does indeed fix the problem for me.
I just found a bug in the current release and beta version of SQL Prompt.
The problem is if you have a snippet with the same name as what you have typed. for example:
SELECT MIN(DO<cursor>
At this point the suggestions come up with the snippet highlighted, if I arrow down to select a column, for example "DOE", and hit tab the snippet is inserted instead of the selected column name. / comments
I just found a bug in the current release and beta version of SQL Prompt.
The problem is if you have a snippet with the same name as what you have typed. for example:
SELECT MIN(DO<cursor>
At this ...