Comments
Sort by recent activity
This would be considered a feature request.
You can direct feature requests to our uservoice forums. http://redgate.uservoice.com/forums/141 ... uggestions
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release. / comments
This would be considered a feature request.
You can direct feature requests to our uservoice forums.http://redgate.uservoice.com/forums/141 ... uggestions
These forums are actively monitored by our...
Sorry you are experiencing this.
I was able to reproduce this behavior and have logged this bug under the internal reference of SC-6447. / comments
Sorry you are experiencing this.
I was able to reproduce this behavior and have logged this bug under the internal reference of SC-6447.
Sorry you are experiencing this.
It appears you have run into a known issue under the internal reference number of SP-4703.
We believe we have fixed this issue. The fix is available in an EAP of SQL Prompt 6.
If you would like, you can install the EAP of SQL Prompt 6. ftp://support.red-gate.com/patches/SQLP ... Prompt.zip / comments
Sorry you are experiencing this.
It appears you have run into a known issue under the internal reference number of SP-4703.
We believe we have fixed this issue. The fix is available in an EAP of SQ...
Thank you for your input.
There is an existing feature request for the ability to add a description to database roles under the internal reference number of SDOC-1035.
I have added your details to the existing request. / comments
Thank you for your input.
There is an existing feature request for the ability to add a description to database roles under the internal reference number of SDOC-1035.
I have added your details to ...
0x80070005 indicates permission issue.
Check the security on the file TextMgrP.dll (Right-click the file in Explorer, choose the Security tab and ensure the user has appropriate permissions).
Click the Start Button, then in the "Start Search" box type CMD but DO NOT press Enter yet.
In the list above, under "Programs" right-click on CMD that appears above and choose "Run as Administrator" and click "Continue".
In the black command line window, use the command “REGSVR32†to register the file again. http://social.technet.microsoft.com/For ... gister-dll / comments
0x80070005 indicates permission issue.
Check the security on the file TextMgrP.dll (Right-click the file in Explorer, choose the Security tab and ensure the user has appropriate permissions).
Click...
We have been unable to replicate this in our test environments.
Would you be able to send us snapshots of the databases that the tool struggles with? http://documentation.red-gate.com/displ ... +snapshots
Email them to support@red-gate.com
Include F0074789 in the subject of the email message. / comments
We have been unable to replicate this in our test environments.
Would you be able to send us snapshots of the databases that the tool struggles with?http://documentation.red-gate.com/displ ... +sna...
Can you check that your graphics card drivers are up to date? This has been known to affect the performance of SQL Prompt.
If you graphics card driver is up to date, It may be a case of SQL Prompt struggling with the number of columns in your databases.
By default SQL prompt will attempt to cache all collumns of databases that you are connected to.
Since the memory available to SQL Prompt is limited by SSMS, If you are connected to a large amount of databases or databases with a large amount of columns or a combination of the two it'll eventually fill up its cache of columns for suggestions, but most users don't ever hit that limit. If it does sound like it's just a case of too many columns, there's a few things you can do
1.) There's a config option in %LOCALAPPDATA%\Red Gate\SQL Prompt 5\RedGate_SqlPrompt_Engine_EngineOptions.xml called <MaxSupportedColumns> - you can use this to limit the size (in columns) of a database that SQL Prompt will load. If you set it, to, say, <MaxSupportedColumns>20000</MaxSupportedColumns>, SQL Prompt will give up on loading columns for databases with more than 20,000 columns.
This is really to stop individual giant databases crashing Prompt.
2.) Sometimes just clearing the cache helps. Restarting SSMS will clear SQL Prompt's cache. So when SQL Prompt becomes sluggish you can try restarting ssms before it runs out of memory.
3.) Another option that may help is disabling linked server support in SQL Prompt.
This will prevent SQL Prompt from attempting to provide suggestions from a linked server whose columns will be loaded into SQL Prompt's memory. / comments
Can you check that your graphics card drivers are up to date? This has been known to affect the performance of SQL Prompt.
If you graphics card driver is up to date, It may be a case of SQL Prompt ...
The option is not currently in UI but you can modify it in:
c:\Users\<your login>\AppData\Local\Red Gate\SQL Prompt 5\RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml
Change element IndentBeginToken:
<IndentBeginToken>False</IndentBeginToken>
This equivalent setting is also also in the style file so you can modify the style file and share the style file with other members of your team.
If you would like to request a feature to make this option available from the UI you can vote for this existing feature request in our uservoice forums. http://redgate.uservoice.com/forums/944 ... dent-begin
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release. / comments
The option is not currently in UI but you can modify it in:
c:\Users\<your login>\AppData\Local\Red Gate\SQL Prompt 5\RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml
Change element IndentBeginTok...
This would be considered a formatting feature request.
You can direct feature requests to our uservoice forums. http://redgate.uservoice.com/forums/944 ... uggestions
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release. / comments
This would be considered a formatting feature request.
You can direct feature requests to our uservoice forums.http://redgate.uservoice.com/forums/944 ... uggestions
These forums are actively monit...
This would be considered a formatting feature request.
You can direct feature requests to our uservoice forums. http://redgate.uservoice.com/forums/944 ... uggestions
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release. / comments
This would be considered a formatting feature request.
You can direct feature requests to our uservoice forums.http://redgate.uservoice.com/forums/944 ... uggestions
These forums are actively monit...