Comments
Sort by recent activity
Hi,
I've had a play with this and it seems that if you type quickly -- so that you've typed the @ before the table names suggestions box appears -- then indeed you have to press ctrl-space to force the box to pop up.
When I pause after typing FROM, the Suggestions box appears with the full list of table names. When I then type an @, the list is filtered to @... as you'd expect.
This behaviour doesn't seem to happen when table names begin with a letter, so it does look like a (pretty minor) bug.
Regards,
Paul / comments
Hi,
I've had a play with this and it seems that if you type quickly -- so that you've typed the @ before the table names suggestions box appears -- then indeed you have to press ctrl-space to force...
Hi Ed,
Were your snippets created in SQL Prompt 4? The installation of SQL Prompt 5 should have migrated them across for you, so if that hasn't happened I'd be interested in further details.
Customizations are stored in "%LOCALAPPDATA%\Red Gate\SQL Prompt 4" and "SQL Prompt 5" in the same directory. These are the interesting files:
Snippets (the whole directory)
LoggingConfiguration.xml
RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml
RedGate_SqlPrompt_Engine_EngineOptions.xml
RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml
If your snippets are in the version 4 location, you can copy the files from there to the SQL Prompt 5 location to get them to work.
Please let me know how this goes.
Regards,
Paul / comments
Hi Ed,
Were your snippets created in SQL Prompt 4? The installation of SQL Prompt 5 should have migrated them across for you, so if that hasn't happened I'd be interested in further details.
Custo...
Hi Steven,
Which menu items aren't enabled for you? If you click inside a query window is it any better?
What is the status of your trial period?
Regards,
Paul / comments
Hi Steven,
Which menu items aren't enabled for you? If you click inside a query window is it any better?
What is the status of your trial period?
Regards,
Paul
Yes, we did discover after the release of SQL Prompt 5.0 that CTEs do make SQL Prompt perform very slowly. The developers have now produced a fix, which will be included in SQL Prompt 5.1.
I understand that doing CTE-intensive work is very difficult with the current version, so we've also backported the fix to SQL Prompt 5.0. It hasn’t been fully regression-tested, so we’re only telling people who have told us they’ve experienced this specific issue.
Please email me at paul.stephenson@red-gate.com if you're having problems with slow CTEs and I'll send you the link.
Regards,
Paul / comments
Yes, we did discover after the release of SQL Prompt 5.0 that CTEs do make SQL Prompt perform very slowly. The developers have now produced a fix, which will be included in SQL Prompt 5.1.
I under...
Hi dbaman7,
SQL Prompt 5 Pro will decrypt the stored procedure when you press F12 on its name in a query window to Script as ALTER (or right-click and choose from the menu).
You will also see the decrypted script if the encrypted procedure appears in the code-completion drop-down, and you click on it to bring up the little popup.
Hope this helps,
Paul / comments
Hi dbaman7,
SQL Prompt 5 Pro will decrypt the stored procedure when you press F12 on its name in a query window to Script as ALTER (or right-click and choose from the menu).
You will also see the d...
Hi James,
For performance reasons, the SQL Prompt parser only looks back a certain number of characters to find variable declarations.
By default, this is 5000 characters, but if you are happy editing XML files then it can be changed:
1. Open up "%LOCALAPPDATA%\Red Gate\SQL Prompt 5\RedGate_SqlPrompt_Engine_EngineOptions.xml" in a text editor.
2. Find the tag <ParserLookBackDistance>.
3. Increase the number in the tag from 5000 to something bigger like 30000.
Please be aware that very large values of this option have not been thoroughly tested and may cause performance degradation, so use with caution.
Regards,
Paul / comments
Hi James,
For performance reasons, the SQL Prompt parser only looks back a certain number of characters to find variable declarations.
By default, this is 5000 characters, but if you are happy edit...
Hi Chris,
I've passed on the information to the SQL Source Control team.
Regards,
Paul / comments
Hi Chris,
I've passed on the information to the SQL Source Control team.
Regards,
Paul
Hi Chris,
Thanks for your report. The "Thread was being aborted" error is due to some slightly messy cleanup code, but doesn't affect the user (apart from spamming your event log).
We're going to fix this in SQL Prompt 5.1.
Regards,
Paul / comments
Hi Chris,
Thanks for your report. The "Thread was being aborted" error is due to some slightly messy cleanup code, but doesn't affect the user (apart from spamming your event log).
We're going to ...
Hi all,
Please make sure you vote on SQL Prompt's Feature Suggestions Forum.
Synonyms are currently the second-most-voted-for item and we are reviewing what level of support we might be able to include in a future release. The more votes, the stronger the case for inclusion!
Regards,
Paul / comments
Hi all,
Please make sure you vote on SQL Prompt's Feature Suggestions Forum.
Synonyms are currently the second-most-voted-for item and we are reviewing what level of support we might be able to inc...
Hi s_solt,
It looks like the Feature Suggestions Forum URL has changed slightly. Thanks for pointing out the error.
SQL Prompt will offer auto-completion for synonym names if you turn on the experimental support at SQL Prompt 5 > Experimental Features... > Synonym Suggestions. Please give it a try if you haven't already!
Regards,
Paul / comments
Hi s_solt,
It looks like the Feature Suggestions Forum URL has changed slightly. Thanks for pointing out the error.
SQL Prompt will offer auto-completion for synonym names if you turn on the exper...